[VBA] ACE.OLEDB.12.0 a plik CSV

Article View: pl.comp.lang.vbasic

Article #104788

Back to pl.comp.lang.vbasic Previous Next

#104788

From: Marian
Date: Mon, 21 Feb 2011 22:55

16 lines
1331 bytes

Witam

Nie mogę poprawnie otworzyć rekordseta opartego na pliku CVS (oddzielanego 
średnikami - UTF8 bez BOM).

Przy użyciu providera JET4.0 wszystko gra.
W przypadku Microsoft.ACE.OLEDB.12.0 nie odczytuje separatorów i dostaję 
recordset z jednym polem.


.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & "Data Source=" &
csvPath & ";" & "Extended Properties=""text;HDR=NO;FMT=Delimited(;)"""


Pozdrawiam
Marian

Technical Details

Message-ID: <ijuqgb$865$1@news.task.gda.pl>

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.task.gda.pl!not-for-mail

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.task.gda.pl!not-for-mail
From: "Marian" <marian@qazwsxedc.pl>
Newsgroups: pl.comp.lang.vbasic
Subject: [VBA] ACE.OLEDB.12.0 a plik CSV
Date: Mon, 21 Feb 2011 23:55:15 +0100
Organization: CI TASK http://www.task.gda.pl/
Lines: 19
Message-ID: <ijuqgb$865$1@news.task.gda.pl>
NNTP-Posting-Host: dynamic-87-105-136-82.ssp.dialog.net.pl
X-Trace: news.task.gda.pl 1298328909 8389 87.105.136.82 (21 Feb 2011 22:55:09 GMT)
X-Complaints-To: abuse@news.task.gda.pl
NNTP-Posting-Date: Mon, 21 Feb 2011 22:55:09 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit