DoCmd.TransferText acImportDelim with Tab

K

Ken Wilkinson

I want to use in code DoCmd.TransferText acImportDelim with Tab as the
delimiter. How do I do that without creating an import specification? When I
create an import specification the field list is saved and I need to be open
to changing fields and names.

Thanks in advance
KenW
DB4DP
 

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

Import Specs Changed "Magically" in Midst of Loading Sequence 3
Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
Problem with access acImportDelim importing csv with headers 1
Import Trailing Spaces 8
DoCmd.TransferText acImportDelim, "spec1", "filetmp","filename",false 1
TransferText acImportDelim Problem 5
DoCmd.TransferText error with Schema.ini import specification 5
Help! --- DoCmd.TransferText 6

Top