DataTable into a new SQL table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The requirement is to transfer data from Excel to SQL tables using ASP.Net for user interface. I have populated the excel data into a dataTable of a DataSet using ADO.Net. Now, I would like to know a better way to insert this data into a new SQL table. Since the Excel has more than 30,000 rows with 20 columns , performance is also an issue here. Please help me through your ideas at the earliest.
 
Here's one approach: connect to the Excel data source using Jet OLEDB
and execute a SELECT..INTO query using the IN keyword to specify the
SQL Server target e.g.

SELECT *
INTO [odbc;Driver={SQL
Server};Server=MyServer;Database=MyDatabase;User
ID=sa].[NewTempTable]
FROM [Sheet1$]
 
hi,
thanks . but when i tried the same in my app, it shows an error for ISAM not available...
can u give some solutions for this.
 
Back
Top