Questions

Answer for:

MS Access 2002- Problem importing File

Message 2 of 5

View entire thread
+
0 Votes
dryflies

you say the type of file is fixed delimited. Is it fixed width or is it delimited? in the Access 2002 help under import, the subject data sources you can import or link to gives a choice of delimited text or fixed width text. if it is an import problem more specific info is needed.
However, I think you should look at the table definition and see if the number of characters in (width of) each field is exceeded by any of the rows of data in the import file. You may be trying to import data that will not fit the field definition for that column.
it is more likely to be an access 97 issue allowing the import truncating the data instead of forcing it to be correct.
if this answer is usefull, tell TR.