Dynamically import excel file

HI All,

I am new to .net, I got a project in which i need to import dynamically excel file into sql table. Like user will select the excel file and the sql table, then all the columns from excel file and the fields from sql table comes on the form, then user will select which column need to go to which table colums.

Can anyone help me in this.

Thanks

Arvinder

re: Dynamically import excel file

Hi Friends,

I am still waiting for the solutions, can anyone pls help me.

Thanks

re: Dynamically import excel file

Read the excel file using OLE DB and use Dataset to fill your data and then enter into Sql table..

re: Dynamically import excel file

I have a small programe to import excel file to database that can be usefull with a bit customization. E-mail me at filterking_555@yahoo.com if you still need it.