[VBA] ACE.OLEDB.12.0 a plik CSV

Thread View: pl.comp.lang.vbasic

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Marian Mon, 21 Feb 2011 22:55

#104788

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads