siebel2002
Programmer
I am using the following code to import a .txt file into my access table. It only imports just the first of the total 4 fields.
DoCmd.TransferText _
TransferType:=acImportDelim, _
ImportSpecification: "Security Deposit", _
tableName:=tblDeposit, _
fileName:=filePath, _
HasFieldNames:=fieldHeadings
The remaining field names are shown in the imported table, but not the values!
What am I doing wrong? Help!
DoCmd.TransferText _
TransferType:=acImportDelim, _
ImportSpecification: "Security Deposit", _
tableName:=tblDeposit, _
fileName:=filePath, _
HasFieldNames:=fieldHeadings
The remaining field names are shown in the imported table, but not the values!
What am I doing wrong? Help!