insert more than 50,000 records
-
hai i have more than 50,000 records in excel. i want to insert into a table which is in a sqlserver 2000 database. it takes more time, sometimes it shows timeout expired. is any simplest way to insert the data shortest period? Thanks advance Ganesh Mohan
-
hai i have more than 50,000 records in excel. i want to insert into a table which is in a sqlserver 2000 database. it takes more time, sometimes it shows timeout expired. is any simplest way to insert the data shortest period? Thanks advance Ganesh Mohan
Upload the excel file to your SQL Server, then use SQL Server Data Transformation Services (DTS) to open the file and insert the data into your table for you. It should take a few seconds at most...
------------------------------------------- Don't walk in front of me, I may not follow; Don't walk behind me, I may not lead; Just bugger off and leave me alone!!
-
Upload the excel file to your SQL Server, then use SQL Server Data Transformation Services (DTS) to open the file and insert the data into your table for you. It should take a few seconds at most...
------------------------------------------- Don't walk in front of me, I may not follow; Don't walk behind me, I may not lead; Just bugger off and leave me alone!!
Thanks it works fine. IF anyone known about BCP related to this synario, please explain Thanks in Advance
-
Thanks it works fine. IF anyone known about BCP related to this synario, please explain Thanks in Advance
BCP only works with ASCII text files. You would have to save the contents of your spreadsheet as CSV or tab-separated files first.