I created the barest of my application in Access 2003 using an MDB type file.
I developed an Import specification to import a txt file.
I have attached a sample input txt file and my Access 2003 application.
Do you know why I get empty records with the 2 input records?
For every input record with values that I import , I get an empty record as well.
So if I were to import 100 records from a txt file, I would get 200 records in the Access table (100 records with values plus 100 empty records).
The VBA code is as follows:
Private Sub cmdImport_Click()
On Error Resume Next
DoCmd.TransferText acImportDelim, "IMNYCashBreaks Import Specification1", "OI_Intell_Mod", "U:\Dec20\IMNYCashBreaks.t
MsgBox ("File has been transfered successfully!")