I have created a program in microsoft access VBA where I import a text file into an already created table in my database. For some reason every time i import the file it deletes the first record.
Here is my import specification code
DoCmd.TransferText acImportDelim, "scanner import specification", "scanner", Me.FName, True
My 'scanner import specification' that i have set are not set to skip the first line. In the preview of the import it shows all the data there, but whenever i import the first line is always missing. Whenever I add a blank line in my text file it seems to work.