Hi all,
I have a fairly basic .txt file that I'm trying to import into my database. To start, I do what I normally do and select (in MS Access) External Data | Text File
After selecting the .txt file that I'm importing, I selected the "Delimitted" method since all of the fields on the .txt file are separated by the "|" delimitter.
Then, I clicked the "Advanced" button to create an Import Specification based upon the field names in the table that this file will be imported into.
The issue I'm running into is that there is no header row on the .txt file - the first row on the file is literally the first record that should be imported.
I've confirmed that the "First Row Contains Column Names" option is unchecked when I save the Import Specification. So in theory, it shouldn't be skipping that first row under the assumption that it's a header row.. but it still does nonetheless.
I found another thread about this same issue, but haven't yet stumbled upon a solution other than manually importing it. My intent though is to have the file import upon clicking a button in a form - the OnClick event behind the button links to a VBA procedure which uses the DoCmd.TransferText acImportDelim method, in which I'd also reference the corresponding Import Specification. I'm already doing something like this for other .txt files - but this is the first one I've run into where there's no header row on the .txt file itself, and thus it's skipping over that row while importing it. :-\
https://answers.microsoft.com/en-us/...2-40012ffa923b