By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,570 Members | 999 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,570 IT Pros & Developers. It's quick & easy.

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

100+
P: 254
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.
Jan 28 '10 #1
Share this Question
Share on Google+
3 Replies


Frinavale
Expert Mod 5K+
P: 9,731
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
Feb 1 '10 #2

100+
P: 254
I used OLEDB but sometime connection does not establishes and gives error.
Feb 3 '10 #3

ThatThatGuy
Expert 100+
P: 449
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
Feb 3 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.