I realize this thread is about a year old, but I have a question. Is there a way to use the BULK INSERT and remove/ignore the first line of text? The first line of text has the field names.
Example text file:
"Item" "Quantity" "Price"
"item1" 275 20
"item2" -22 15.75
"item3" -17 22.5
...
Running the query manually errors...
Leave a comment: