TextDelim Problem

  • Thread starter Thread starter Warwick Hunt
  • Start date Start date
W

Warwick Hunt

Hiya All,

I have a problem importing a textfile into an existing access database. When
I use the following line of code I get the rows added but they are all
empty:-

DoCmd.TransferText acImportDelim, , "OdetteA5", "<FileLocation>\text1.txt",
False

Can anyone help, I need to do this programatically for a number of text
files.

TIA

Dave
 
---------- "Warwick Hunt said:
Hiya All,

I have a problem importing a textfile into an existing access database. When
I use the following line of code I get the rows added but they are all
empty:-

DoCmd.TransferText acImportDelim, , "OdetteA5", "<FileLocation>\text1.txt",
False

Dave,

how's the structure of the text file?

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de
 
Back
Top