unable to read data from excel 5/95 using c#

Question

0.00/5 (No votes)

See more:

Hello,
In my application I am converting excel data into dataset using microsoft.jet.oledb driver. I have used oledb 4.0 and excel 8 in connection string. It works fine for excel 2003 but I have to convert data from excel 95 also which is system generated file. At that time I am not getting anything in dataset. When I save as that file in latest version it works fine. I tried using excel 5 in connection string but it didnt work. Please help me or suggest some alternative.

Thanks in advance...

Posted 7-Oct-14 5:05am

betu.009

Add a Solution

Comments

Richard Deeming 7-Oct-14 11:08am

Support for such an old version is going to be difficult.

See if NPOI[^] can open the file.

betu.009 7-Oct-14 11:15am

ya i know, but its a requirement. I have to do it.

Richard Deeming 7-Oct-14 11:21am

Looks like NPOI won't work:
http://apache-poi.1045710.n5.nabble.com/Reading-Excel-5-0-7-0-files-td2302502.html[^]
(NB: NPOI is a port of the Java POI framework.)

NExcel[^] claims to support Excel 97, and is a port of a Java API[^] which claims to support Excel 95, so it might work.

Maciej Los 7-Oct-14 11:10am

What exactly have you tried till now?

betu.009 7-Oct-14 11:14am

I tried to change the connection string made excel 5, but it didnt work. I thought to open file programmatically and save as it in latest version. Dont know how to do it but i think it should work. Please suggest something

Maciej Los 7-Oct-14 11:19am

By saying "what exactly" i wanted to know how connection string has been defined. Please, see solution no. 1 by RyanDev.

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)

ZurdoDev · Answer 1 · 2014-10-07T05:15:00

Solution 1

It will be hard to find information on a 20 year old product; however, this link seems to have some samples that work.

http://stackoverflow.com/questions/2246797/get-sheet-names-in-excel95-workbook-using-oledb[^]

Posted 7-Oct-14 5:15am

ZurdoDev

Comments

Maciej Los 7-Oct-14 11:18am

5ed!

betu.009 7-Oct-14 11:20am

I have already tried this one. But it didnt work. Thanks for the reply

ZurdoDev 7-Oct-14 11:22am

Then please click on Improve question link and post the code you have tried. If other people say it works then something must be different about what you are doing.