Import text data

[Guest]

Hi:
I'm trying to automate the import of data.

I use the File Import to save a Test Link Specification.

DoCmd.TransferText acImportDelim, "Test Link Specification", "table3",
"C:\test\test.txt", False

The code executes with no error, but no data is
imported into the table.

Any help would be appreciate.

Thanks,
Phil Miller

 

[David Lloyd]

Phil:

One thing to check is to see if "_ImportErrors" table has been created. If
the specification is not correct for some reason, it can cause the import to
generate errors which are recorded in the "_ImportErrors" table. Instead of
importing the data into the specified table, it instead makes an entry in
this table. If this table has been created, it should give you a hint as to
what caused the errors.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi:
I'm trying to automate the import of data.

I use the File Import to save a Test Link Specification.

DoCmd.TransferText acImportDelim, "Test Link Specification", "table3",
"C:\test\test.txt", False

The code executes with no error, but no data is
imported into the table.

Any help would be appreciate.

Thanks,
Phil Miller