Date/Time Field Import Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a .csv file with the following data in RunDate:

2/3/2007 10:50:03 AM

I get a type conversion failure error on this field, even when it is
specified as a Date/Time field with MDY.

I've seen the postings on creating a temp table and importing the field as
text, and then fixing it in the perm table through an append query. Are
there any other options?
 
Kirk

Given that the odds are pretty good that the .csv data is NOT
well-normalized, importing all data as text into a "temporary" table, then
running parsing queries to put the data, as appropriate, into your permanent
(and well-normalized) Access tables may be a "best practice" idea.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
OK, that's what I ended up doing.

Thanks!

Jeff Boyce said:
Kirk

Given that the odds are pretty good that the .csv data is NOT
well-normalized, importing all data as text into a "temporary" table, then
running parsing queries to put the data, as appropriate, into your permanent
(and well-normalized) Access tables may be a "best practice" idea.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Back
Top