data import error

  • Thread starter Thread starter young
  • Start date Start date
Y

young

The date field data is not importing. The data type in
the table is "Date/Time" and when I import I specify the
data type as "Date/Time" in the appropriate fields of the
CSV file and it still does not work. Please help.
 
In the 'Advanced' section of your import specifation,
check the date_order format. Make sure the formatting is
set in the same order as your data field. For instance if
your data field looks like 2003 Jan 1, your import spec
date_order should be in the YMD.
 
You must log in or register to reply here.

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

Type Conversion Error While Importing (Time Field) 8
Importing Text Files Into Access 1
Date/time field changing seconds to all zeros 3
Which is the best MBOX Converter Tool different formats conversion? 4
Import files into access 1
TYPE CONVERSION FAILURE - text to text field 3
Record limit CSV import and more - Access 2002 SP3 1
Date/Time questions 13

Back
Top