Dynamically import excel file

[arvinder]

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

[arvinder]

Pls Reply

Hi Friends,

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

Thanks

[PRR]

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

[VietPP]

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.