Re: Cannot open csv file using Jet.OLEDB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Artur Loewen (artlow_at_gmx.net)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 14:29:36 +0100

for me it worked only with a schema.ini like this:

[Dummy.csv]
ColNameHeader=True
Format=Delimited(,)
TextDelimiter="
CharacterSet=ANSI
DateTimeFormat=ddmmyyyy
DecimalSymbol=.

"NMM" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:55AE1486-026A-4027-93B3-5F119F50C9F6@microsoft.com...
> I'm trying to open csv file from ado but i'm receiving the error "Could
not find installable ISAM "
>
> KB209805 doesn't help
>
> here is the connection string:
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dummy.csv;Extended
Properties="""text;HDR=Yes;FMT=Delimited""";Persist Security Info=False

Relevant Pages

  • Cannot open csv file using Jet.OLEDB
    ... I'm trying to open csv file from ado but i'm receiving the error "Could not find installable ISAM " ... here is the connection string: ...
    (microsoft.public.data.ado)
  • Re: CoInitialize has not been called
    ... >receiving this error when compiling. ... If you are creating a Dll or a Service or try to use ADO out of a Thread you ...
    (borland.public.delphi.database.ado)
  • Re: Oracle Blob 4000byte limitation
    ... Chris Fink wrote: ... > I am receiving the following error when I attempt to insert into a ... > In investigating this, it looks like ADO had a solution using the ...
    (microsoft.public.dotnet.framework.adonet)
  • Object was open
    ... How I post a table with master/detail, with ADO and MSSQL2000, I am ... receiving an "Object was open" error. ... --- posted by geoForum on http://delphi.newswhat.com ...
    (borland.public.delphi.database.ado)