In Access 2013 I am trying to import a comma separated text file. The first row will not import, I get Type conversion Failure. But when I do it manually using the wizard I have no issue. Here are the first few "columns" in the text file:
Data Filename,Sample Name,Sample ID,Androstenedione,Androstenedione 13C3,Cortisol,Cortisol D4
Yes those are headers, but they can change with every file so I feel it would be easier to just import them as regular data and deal with it with some programming. The first 3 "columns" work fine, but after Sample ID none of the others will work, they all get the Type Conversion Failure. I checked the table and all the fields are Short Text.
Here is the vba line:
DoCmd.TransferText transferType:=acImportDelim, SpecificationName:="", TableName:="NoPound", FileName:="C:\OMNI LIS\Preconversion\NOPound.txt", hasfieldnames:=False
Does anyone have any idea why the manual way works but the vba does not?