Import tab delimited text file to access database

Question

I have a tab delimited text file and you want to import it into MS Access using VBA code.

I created an MS Access form and used the method DoCmd.TransferText:

DoCmd.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

This works well for a CSV file. I am not sure how to do this with tab delimited text files.

Any suggestions?

Answer 1

Make a manual import by changing the separator to TAB, save the import specification, and then specify the import specification in the TransferText command.