detect bad files during import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am able to import comma delimited file with the docmd.transfertext
statement in vba. Suppose my import specification defines five (5) fields but
if a text file has more than five and the order of the fields is wrong (say
only the first 2 columns is correct), I found Access does not complain. I
thought Access will error out from my codes but it didn't complain. Have I
missed anything?

By the way, my application has the first row in the import file containing
column information. And I am importing all columns as text in my
specifications.
 
I think Access will just ignore the extra Field values in the row.
 
You must log in or register to reply here.

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

Importing Text Files Into Access 1
custom warning message for data import 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
error trapping import error 8
Import text file data conversion problem in Access07 2
An error occurred trying to import file 'c:\temp\import.txt'. The file was not imported. 0
importing data 1
Access 2003 Import Specs 1

Back
Top