Loading

Read Data From Excel Sheet

BaluReddy Kovvur

14y1.7k.NET

Hi,

i want to read and insert excel data into database(sql server 2008).

but ms office is not installed in server(i.e application hosted server).

how to solve this issue.(i have tested with codeplex third party dll it is not working for all cases).

please suggest any code or third party open source dll.

Thanks In Advance,

Balu Reddy

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

BaluReddy Kovvur14y ago
Hi,

thanks for reply.

but i think office installation is required for the suggested dll.

Regards,
Balu K
0
Datta Kharad14y ago
Hi..
You can use Microsoft.Office.Interop.Excel.dll this dll and try it.
0