Import Specification Problem.

S

Scott Burke

OK.. I am importing a space delimited file. I can import the pps-test.txt
into "Import UMC"(the table) using a file Specification. When I do this
manuall I have no problems.

The Problem.
docmd.transfertext acImportDelim, "PPS-Import Specification","Import UMC",
[Filenm], false

When I try to do this with the above command line I have a problem. Only
the first field imports correctly. The rest of the fields are null.?

Why will it work manually but not by code?
Scott Burke
 

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

3625 error 1
Text Import Specification Missing 3
Access is dropping rows on import 1
Lose primary key when importing 3
Import Specs Changed "Magically" in Midst of Loading Sequence 3
Excel Import Specification 2
Catching an Error from Queries? 0
Access Project SQL Import csv 4

Top