Answer for:

MS Access 2002- Problem importing File

Message 5 of 5

View entire thread
0 Votes

I just tried importing several text files (some tad delimited, some fixed width into Access 2002 and had no problem. I agree with the other responder that it is more likely to be an Access 97 error rather than Access 2000.

I am assuming you are importing the file to a new table. I wonder if there is an issue with the text file. It is possible that some delimiters are located in such order that Access has a hard time figuring out what the columns are.

Try importing only one row to see if the import works (make a copy of the file and delete everything but one row of date). If that works you know the issue may not be with Access, so try importing several rows, and check the text file.

Another idea is to make sure you have all text converters installed (under Office installation).

If you are importing the file into an exsting table, check the tabe design. Possibly one of the columns needs to be modified to allow for more data.

Hope this helps.