Error importing dates from fixed width txt files

L

Lisa

I'm trying to revise an existing Import Spec to include new fields added to a
fixed width text file. If I import without making any revisions the dates
import correctly. They are on the file as CCYYMMDD and the data field in the
Spec is Date/Time and I've deselected 4 digit year. My new date fields were
added to the text file as YYMMDD and I select Date/Time data field for the
new fields. However, with the revisions made adding the new fields none of
the date fields import now with the revised spec.

Another user created the spec and we're both using Access 2003 with the
database in Access 2000 format. Any ideas on what could be causing this
error?
 

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

Access2007: Import Error; worked in 2003 0
Access 2000 database Import Spec not working properly 1
Importing Fixed Length File into Access 2007 1
Hex 0D 0A 1A at end of imported file 1
Import text file with macro - Invalid argument (Error3001) 0
Exporting Fixed Width Text File 4
Access 2003: Import Extensionless Files 3
Import text file data conversion problem in Access07 2

Top