Date/Time Field Import Error

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?
 
J

Jeff Boyce

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
 
G

Guest

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...
 

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 error only with code 1
Import CSV Type Conversion Failure 3
Expected Date/Time Format During Table Import 1
Import spreadsheet with modified date 1
|9 can't find the field '|' Error when importing a csv to Access 2 0
Importing date problems in CSV 1
why "Type Conversion Failure" import EXCEL into ACESS TEXT field 1
import csv conversion & import spec error 1

Top