获取错误当尝试打开csv文件时找不到可安装的ISAM [英] Getting error as Could not find installable ISAM when try to open csv file

问题描述

我正在使用以下代码打开csv文件，但最终错误为无法找到可安装的ISAM。

I'm using the below code for opening a csv file but ending up with the error as "Could not find the installable ISAM".

Conn1 = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = D:\\Sample;""Extended Properties = ""text;HDR=Yes;FMT = Delimited(;)"";Persist Security Info = False"

请为我建议一个解决方案。

Please suggest me a solution for this.

推荐答案

我已经运行了一些测试，并且有一个连接字符串中的错误。你有

I have run some tests and there is an error in your connection string. You have

Conn1 = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = D:\\Sample;""Extended Properties = ""text;HDR=Yes;FMT = Delimited(;)"";Persist Security Info = False"

但是我使用了以下工作：

But I used the following which works:

Conn1 = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = D:\\Sample;Extended Properties = ""text;HDR=Yes;FMT = Delimited(;);Persist Security Info = False""";

注意连接字符串中双引号的位置;所有扩展属性都应该在一组引号内，例如：

Note the positioning of the double quotes within the connection string; all the extended properties should be within the one set of quotes like:

Extended Properties = "<all extended properties go here>" 

根据我的经验，有三种可能的原因：



1）未安装可安装的ISAM（索引顺序访问方法）驱动程序。这是最可能的原因。 ISAM包括文本文件和DBF。以下链接完整地解释了这些以及您需要的支持文件。通常我通过在我的Office安装中更新Access的导入/导出选项来安装它们：

http：// support.microsoft.com/kb/209805 [ ^ ]



2）文本驱动程序已安装但尚未初始化，请参阅：

http://office.microsoft.com/en-us/access-help/initializing-the- text-data-source-driver-HP001032166.aspx [ ^ ]



3）错误在于说谎！我只记得在DBF文件和旧版本上看到这个。典型的原因曾经是具有长文件名的DBF，尽管最近的消息是找不到文件。如果上面没有解决问题，我会尝试在一个简单的文件夹中加载一个短名称的文件（例如，C：\\\\test.csv），但如果你自己加载了1或2没有解决问题！

There are three possible causes from my experience:

1) The installable ISAM (Indexed Sequential Access Method) driver is not installed. This is the most likely cause. ISAMs include text files and DBFs. The following link explains these in full and what support files you need. Typically I install these by updating my import/export option for Access in my Office installation:
http://support.microsoft.com/kb/209805[^]

2) The text driver is installed but not initialized, see:
http://office.microsoft.com/en-us/access-help/initializing-the-text-data-source-driver-HP001032166.aspx[^]

3) The error is lying! I can only recall seeing this on DBF files and older versions. A typical cause used to be a DBF with a long file name, although more recently the message for this is "Couldn't find file". If the above do not fix the problem, I'd attempt to load a file with a short name in a simple folder (e.g., "C:\test\test.csv"), but you're on your own if 1 or 2 didn't fix the problem!

这篇关于获取错误当尝试打开csv文件时找不到可安装的ISAM的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！