accessing excel at the client side for processing

Question

4.00/5 (1 vote)

See more:

Hi,

I have created an web application which takes three excel files from the client side which compares and processes those excel sheets and then updates the same excel sheet. I have used ODBC provider.

After deploying the application over a server the file upload control takes the path of the excel files and looks for it on the server.

I was just wondering could it be a problem with the connection string? Like in Sql Provider connection string we use the DataSource attribute to specify the server.

Is there any attribute that will do the same for the connection string I have for ODBC provider?

Please help me out here, this is my very first project in .net

Thanks in advance :)

Posted 16-Mar-11 6:06am

MohamedHassanAli

Updated 16-Mar-11 7:20am

thatraja

v4

Add a Solution

Comments

Dylan Morley 16-Mar-11 12:30pm

Edit for readability

Sergey Alexandrovich Kryukov 16-Mar-11 13:12pm

Ha-ha-ha! Excel as a database... most popular database as one publications said. What a waste!
Sorry for you.
--SA

fjdiewornncalwe 16-Mar-11 22:40pm

Seriously Mohamed, you really have to consider that the architecture of this solution is simply never going to be a good idea this way. Working with Access is even a better idea. As a highly experienced developer I would much rather stick my hand in a pool full of jelly fish than work with this setup.

MohamedHassanAli 17-Mar-11 3:30am

I know working on excel is such a pain Marcus and SA. But still thing are a little bit fine now. Somehow its working. I couldnt deploy it at a server instead deployed it in the user machine itself. Thank you all :)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Micha3ldg · Accepted Answer · 2011-03-16T22:32:00

If you are really sure about the excel as your backend.
Try this to add into your appconfig section in app.config or web.config file.

<add key="ExcelConnectionString" value="OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[Your excel file path here];" />

Example

<add key="ExcelConnectionString" value="OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\excel.xls;" />

in your code behind add this

string constr = ConfigurationManager.Appsettings["ExcelConnectionString"];

this way you can always change the path of the excel without rebuilding your project.

and try to be more resourceful. use the google.