
October 7th, 2007, 05:26 AM
|
|
Registered User
|
|
Join Date: Sep 2007
Posts: 2
Time spent in forums: 31 m 26 sec
Reputation Power: 0
|
|
|
Skip rows in bulk insert
I am using bulk insert to upload .CSV file to SQL Server.
I want to skip 1st three rows of .CSV file.
I am using FIRSTROW = 4 in bulk insert but it is giving me error.
I think FIRSTROW works only if there are same no. of columns
First three rows are not having 4 columns,there are just like title.
Is there any solution for this.Plz give in details.
CSV file looks like -
STOCK EXCHANGE
----------------------------
NO. OF ORDERS : 100
ORDER_NO, BROK_ID, BRANCH, USR_ID
2.00707, 10412, 31, 18274
2.00707, 10412, 31, 18274
2.00707, 7536, 5, 4278
2.00707, 7536, 5, 4278
|