integrate excel in asp.net

try this code


Insert into <tablename> Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\test.xls;HDR=YES', 'SELECT * FROM [sheet1$]')


above directly execute in Query window change the Excel Path(D:\test.xls)

thanks buddy

in the table columns there is Id which is primary key
and if i use ur logic then what about data which is already in sql server and
if i insert the excel data which is a copy the old sql then 2 entries added of same data,
if i delete the old data and then insert data from excel then the Id column which is auto generated and other tables what refer that filed as foreign key, then what ?

its break the table.

is it possible the user will see the excel in asp.net page


thanx

Try this code to import excel to a datagrid:

http://dotnetguts.blogspot.com/2006/10/import-excel-to-datagrid-aspnet.html

thanx anv

but i requirement is user work on excel sheet and its saved in db
not datagrid

it was for your point:
>>is it possible the user will see the excel in asp.net page

http://www.dotnetjohn.com/articles.aspx?articleid=54