cannot import DATE field from csv file

  • Thread starter Thread starter Ziek
  • Start date Start date
Z

Ziek

I have a csv file and one of the fields in that file contains dates of the
following format: 04/30/2003 11:48:11 AM

Everytime I import this data into access, it doesn't import and shows up in
a conversion errors table.

How do I import dates like this into access, from my csv file?
 
Ziek,

Are you trying to import at an alreay existing table, and the table field is
date.time type? If that's the case then that's the source of the problem,
Acces is most likely importing the field from the .csv file as text. See if
you can resolve the problem by changing the way Access reads the field in
the File Import Specification. If that doesn't work, then instead of
importing directly, link the .csv file and then use an update query (or a
make-table one if the destination table does not already exist), and in the
query design add a calculated field using DateSerial and / or TimeSerial
functions in combination with left/mid/right ones to convert the field to
date/time format.

HTH,
Nikos
 
Back
Top