Y
ykffc
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.
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.