Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imranabdulaziz
Yak Posting Veteran
83 Posts |
 Posted - 2009-04-06 : 05:18:29
|
| Hi all,I am using sql server 2005 ,asp.net2.0 , C#. I want to upload data from excel to sql server tables. In the end if all data uploaded then delete all rows in excel else left only those row which are not uploaded successfully with error description.please suggest some idea.Please Help |
|
|
asgast
Posting Yak Master
149 Posts |
Posted - 2009-04-06 : 07:03:19
|
| what kind of sql server you are using? 32bit or 64bit?if its 32 then use Microsoft.Jet.OLEDB.4.0it can directly import excel files into tablesimport data into temp table and then decide what needs to be updated what to be deleted and what to be insertedthere are no jet drivers for 64bit serveralso you can save excel file as text comma or tab separated and then bulk insert it |
 |
|
|
|
|
|
uploading excel data to sql server tables