0
I have an Excel worksheet that looks like this:
MONTH WIDGET QUANTITY COST
Jul-09 Widget1 1000 1.00
... <repeat a few thousand times> ...
I would like to import this into Access, but unfortunately the Access date/time formats don't seem to be compatible with Excel's.
How can I import this data? I'm using the latest versions of Excel and Access 2010.
What CSV exporting has to do with this question, I don't know. Date formatting in Excel (which is all that's involved in the question) itself is similar to Access, i.e., it's a display format, not a data storage format. Unless you're actually storing the literal string "Jul-09" in Excel, it's actually stored as the numberic value for Jul 1, 2009, just as it would be in Access. – David W. Fenton – 2011-08-05T19:59:40.380