How can I use MS-excel as backend of windows app in C#?

Question

1.00/5 (2 votes)

See more:

i would like to design a one window form app but i would like use backend as MS-EXCEL in the place of database ? it is possible or not ? if it is possible !! please explain how it is ?

What I have tried:

I am only try from database .it is successful from database. now I am required from MS-EXCEL

Posted 1-Jun-16 7:41am

Member 12559840

Updated 1-Jun-16 13:51pm

Add a Solution

Comments

ZurdoDev 1-Jun-16 14:05pm

You change your connection string to be one that supports excel and then the same code can work that you used to access a db.

Sergey Alexandrovich Kryukov 1-Jun-16 14:23pm

Bad idea. (Required by who? :-) Excel is nothing like back end. However, it's a popular misconception to consider Excel as a database, especially haunting certain industries. With equal success, you can consider something like a plain text file as a "database". All you need to do it to get rid of this illusion. Either use "real" database management systems, or use Excel (but why?) without pretending you are dealing with the database.

Let me tell you: one of the strongest signs of low-tech development (which does not mean simple or easy) is using Microsoft Office.

—SA

2 solutions

Solution 2

Quote:
it is possible or not ?

Possible ? Yes
Efficient , No

the problem with Excel is that any query is done by using brut force. Any query require to read every record of the database one by one to check the query conditions.

Posted 1-Jun-16 13:51pm

Patrice T

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)

Dave Kreskowiak · Accepted Answer · 2016-06-01T08:58:00

Solution 1

Though it is possible to query an Excel workbook like a database, it makes a very poor database engine. Just don't do it.

Posted 1-Jun-16 8:58am

Dave Kreskowiak