I am trying to bring a group of .txt files into my SQL database.
I have been able to get 1 file to load, but have the following issues.
1) the first row of the file is being skipped by the insert
2) I need the name of the .txt file to be a field
Can anyone help me or point me in the right direction?
(please be gentle, I am a novice.)
Table creation, Insert and Results attached.
Test file attached.