I am a pretty saavy user, but I am having a real problem with the
DoCmd.TransferT ext operation.
I manually used the File>Get External Data> Import routine to set up an
import specification. It works like a champ everytime it's run.
If I use VBA to execute a TransferText and specify the specfile, I get
a Type Conversion Error on import and a table full of empty records
(equal to the number of lines in my import data file).
My data source file is a fixed-length text file.
Here is my VBA line:
DoCmd.TransferT ext acImportDelim, "MySpec", "tblTemp", "C:\MyData" ,
False
I have tried a lot to get this to work.
I first let Access import it into a new table that it created. Then I
opened it up and copied down the data types. I then specified the same
data types in my import table (tblTemp).
The data file has 10 fields. The first and seventh fields are vbLong
types, the others are vbText types.
It's always erroring out on the first field.
Again, it always works fine when manually launched through the menus.
Any suggestions? I'm stuck until I find a solution. Thanks in advance.