无法使用c＃从excel 5/95读取数据 [英] unable to read data from excel 5/95 using c#

问题描述

您好，

在我的应用程序中，我正在使用microsoft.jet.oledb驱动程序将Excel数据转换为数据集。我在连接字符串中使用了oledb 4.0和excel 8。它适用于excel 2003，但我必须从excel 95转换数据，这也是系统生成的文件。那时我在数据集中没有得到任何东西。当我在最新版本中保存为该文件时，它工作正常。我尝试在连接字符串中使用excel 5，但它没有用。请帮助我或建议一些替代方案。



提前谢谢...

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...

推荐答案

很难找到20年的信息旧产品;但是，这个链接似乎有一些工作的样本。



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

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[^]

这篇关于无法使用c＃从excel 5/95读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！