[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 23:55

#102306

Author: "Marian"
Date: Mon, 21 Feb 2011 23:55

20 lines
440 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.


.C & "Data Source=" &
csvPath & ";" & "Extended Properties=""text;HDR=NO;FMTÞlimited(;)"""


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