Using BULK INSERT to insert rows from SQL Server dataset to table |
 |
EXPERT RESPONSE FROM: Roman Rehak
|
|
|
|
| > |
QUESTION POSED ON: 20 February 2008
I am importing data from a.xls file. First I took the data in the dataset and called the INSERT stored procedure. The problem is that while calling the INSERT stored procedure, the stored procedure is called to each row for the dataset. How can I use BULK INSERT for inserting all rows from a SQL Server dataset to a table?
|
|
|
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
