Import Specification

[Woody666]

I would like to see the Import Specification changed such that if you define
all the fields then they are the fields that will appear in your table. Ive
found on numerous occassions that because the first 100 or so records don't
contain data within a field that I have specified that that field is omitted
on the import. I know I can get around it by adding a record which does have
data in this field at the top of the file, but most of the time I need to
import the file as is without modifying it in any way.

 

[Jeff Boyce]

Woody

Consider another approach... If you create a "temporary"/import table in
Access that has the field types you will need, you won't need to rely on
Access' "interpretation" of incoming data.

Once your data is imported into your "temp" table, you can use queries to
parse it and update/append to your "permanent" tables.