Is there a way to read in comma delimited file into Recordset?

[ghost2]

I have a comma delimited file that has the first row is row headings. How can I read this into a recordset in VB6? This program was in Access 2K and the code was first creating a temp table. Thanks all

 

[Forri]

hmm!

you can open the file using 'OPEN', skip the first line.

Then start reading line by line and SPLIT the contents into an array : array = split(Line1, ","). Then array[0] will be the first column etc

Then just perform an insert or an update depends on the type of inserts your doing!

Hope that helps!

Nick

 

[DrJavaJoe]

Try this:

Dim adoConn As New ADODB.Connection
Dim adors as new Adodb.Recordset adoConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strPath & ";" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited"""
adoRS.Open "Select * From " & strFile & "", adoConn, _
adOpenStatic, adLockReadOnly, adCmdText

"Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'."

 

[ghost2]

Thanks DrJavaJoe. Have a great upcoming weekend.