Excel dates import incorrectly

M

Marni

How can I get the Excel dates to import into Access in the date format? They
keep importing as a string of numbers (i.e. 39753 instead of 11/1/2008)
 
D

Douglas J. Steele

Actually, 39753 IS 01 Nov, 2008:

?Format(39753, "Short Date")
2008-11-01

Is the field in Access a Date/Time field or a numeric field?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV import to Access 2007 - problem with dates 2
Problem Importing records with Date/Time data type into an Access 2007 data table 0
Import errors w/dates 3
Import from Excel with some bad dates causes no records to import 1
Import Excel text field to Access date field 3
Import Excel dates as text 5
Import from Excel - Subscript out of range 2
exporting a table to SAS - date errors 1

Top