from excell file to sqlServer

[Guest]

Hi,

I have an excell file with 4 sheets. I want to read each sheet (with VB
..net) and insert it to different tables in my database.. How can do that in a
smart way?

 

[Guest]

Hello,
You should read your excel sheets, there is a smart way to do so by using an
oledb connection, using sql statements
there is a wrapper code that will help you reading/writing your excel file
take a look at this code:
http://www.codeproject.com/csharp/Excel_using_OLEDB.asp

GOOD LUCK
Regards,
Rotem