Import z pliku csv do recordseta - VB6 - Article 104653 - go-pugleaf

Article View: pl.comp.lang.vbasic

Article #104653

Back to pl.comp.lang.vbasic Previous Next

Import z pliku csv do recordseta - VB6

#104653

From: Jarosław Kozik - HOME
Date: Sat, 05 Jun 2010 18:37

24 lines
1593 bytes

Witam wszystkich
próbuje importować dane z pliku csv do grida i nie mogę rozdzielić danych 
zgodnie z przecinkami:

zaczytuje dane :

Dim objConnection As New ADODB.Connection
Dim objRecordset As New ADODB.Recordset

objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                   "Data Source=" & "D:\Text;" & _
                   "Extended Properties=""text;HDR=NO;FMT=Delimited"""

objRecordset.Open "SELECT * FROM file.csv", objConnection, adOpenStatic, 
adLockOptimistic, adCmdText

i do tego momentu jest OK, dane w rzędach są sklejane w jenda kolumne. Jak 
je podzielić na kolumny ??

struktura danych jest następująca:

"dane1a","dane2a","dane3a"
"dane1b","dane2b","dane3b"
"dane1c","dane2c","dane3c"

Technical Details

Message-ID: <hue5g4$cba$1@news.onet.pl>

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.onet.pl!not-for-mail

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.onet.pl!not-for-mail
From: Jarosław Kozik - HOME <jkozik@op.pl>
Newsgroups: pl.comp.lang.vbasic
Subject: Import z pliku csv do recordseta - VB6
Date: Sat, 5 Jun 2010 20:37:00 +0200
Organization: http://onet.pl
Lines: 27
Message-ID: <hue5g4$cba$1@news.onet.pl>
NNTP-Posting-Host: 89.187.233.73.ip.abpl.pl
X-Trace: news.onet.pl 1275763012 12650 89.187.233.73 (5 Jun 2010 18:36:52 GMT)
X-Complaints-To: niusy@onet.pl
NNTP-Posting-Date: Sat, 5 Jun 2010 18:36:52 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-RFC2646: Format=Flowed; Original
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit