Sql a .csv file

langer123 · April 16th, 2005, 08:57 AM

Is it possible to SQL a .csv file. The file has many rows, i have the primary key from one row and need to select all records from this row.

Thanks in advance

pgtips · April 18th, 2005, 03:49 AM

Yes, you just need a text driver, for example the Jet 4 driver which is usually used to connect to Access can also be used for text files. You need a connection string like this:

Code:

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\your_path\;Extended Properties=""text;HDR=No;FMT=Delimited"""

'Note that the Data Source is the directory that contains the csv file.  
'The name of the actual file goes in the SQL statement, e.g.
oRS.Open "Select * From MyFile.csv", oConn, adOpenStatic, adLockReadOnly, adCmdText

hth
Phil

langer123 · April 18th, 2005, 08:55 AM

Thank pgTips, was really helpfull