how to write from excel to data table when ms office is not installed on the server

[mukeshrasm]

Hi

I have to write data from excel to data table on my server and ms office is not installed on the server. I am able to save the excel file but I don't how I can write it to data table from excel when ms office is not installed.

[Frinavale]

I've never used excel as a database for an application...but it looks like you can use OLEDB to connect to and manipulate excel sheets. So, maybe you don't need to have excel installed?

There is a redistribution package provided by Microsoft for it's Office suit. I remember looking it up a few months ago for someone else.

-Frinny

[mukeshrasm]

I used OLEDB but sometime connection does not establishes and gives error.

[ThatThatGuy]

using OLEDB isthe best and the simple way to retrieve data out of excel files....


if youre getting error connecting, check for the version.... of the excel file your'e accessing and the version specified in the connection string...

and also check that the excel file is not open when youre accessing the file through code