Transfer Text - Getting No Data

[JesseH]

I am using the transfer text command with import specifications. I am geting no data (none). I have deleted the import spec completely and re-entered it. Same results. The import file has a blank as a first character and I have used "Filler1" with the "Skip" option. I have even removed the "Skip" options for the Fillers (have 9 of them). No help. I would have expected to get some data albeit wrong if my field definitions were wrong.

Any Ideas?

Thanks In Advance for the help.

 

[bosully]

I did a bit of work with the TransferText macro recently and when I encountered something like this, I found that Access was taking in fields from the text file which were numeric, assigning them to integer variables and then failing to load them to the tables as the fields were set as Text. It may be worth checking if this is what's going on.

Brendan