I am using:
DoCmd.TransferText acImportDelim, , "tablename", "c:\something.txt", True
If I do the import manually it works fine, but if I do it as above the data comes in as one field with the little squares (tabs) seperating the fields.
I thought the above code (by default), would import the file as a Tab delimited file. I can split it using code but surely the above vba is correct and it should work ok. This is how it looks
Ref Number_QS ref_Name Field names as one field
001
234
text Indiv recs as one record
This is something I must have done a 100 times before. Where am I going wrong?
Cheers 4 any help,
Nick
DoCmd.TransferText acImportDelim, , "tablename", "c:\something.txt", True
If I do the import manually it works fine, but if I do it as above the data comes in as one field with the little squares (tabs) seperating the fields.
I thought the above code (by default), would import the file as a Tab delimited file. I can split it using code but surely the above vba is correct and it should work ok. This is how it looks
Ref Number_QS ref_Name Field names as one field
001
234
text Indiv recs as one record
This is something I must have done a 100 times before. Where am I going wrong?
Cheers 4 any help,
Nick
