open excel file C# ?

npqk · November 23rd, 2004, 02:32 AM

Hi all !

How can I open and load an excel file on the datagrid, then save it into my databae SQLserver. I use C#.

r_ganesh76 · November 26th, 2004, 05:06 AM

You can use ADO.Net to access the excel file and then can do the update to your SQL DB

Regards
Ganesh

pradeep_itguy · November 26th, 2004, 10:31 AM

Look at the following Microsoft link to query Excel data

http://support.microsoft.com/kb/306572/EN-US/

It is not how much we do,
but how much love we put in the doing.

-Mother Theresa