Tab Delimited Import Macro

[RandDUser]

I am trying to write a macro to import an .txt file that is tab delimited. The problem I run into is that on the import, it keeps all the data in the first field. Here is the code I have:

Private Sub Command0_Click()
DoCmd.TransferText acImportDelim, , "tbl_Main", "C:\text file.txt", 0
End Sub

Any suggestions?

Thanks!

 

[rjoubert]

I would suggest creating an import specification. The name of your specification would be the second parameter in your line of code.