Can I bulk insert to specific columns when bulk inserting a text file or do I have to bulk insert into all columns of a table? The extra column in the table is an identity integer. So I had to create a view without the identity integer to make it work. Maybe there is a more direct way??
If so what would be the syntax? I am a beginner to intermediate SQL guy.
strSQL = "BULK " & _ "INSERT CustomersUpload " & _ " FROM 'C:\MydataFile.txt' " & _ " WITH " & _ " ( " & _ " FIELDTERMINATOR = '|', " & _ " ROWTERMINATOR = '\n' " & _ " )"
View Complete Post