Forum Home
Press F1
Thread ID: 18478	2002-04-25 22:55:00	loading *.csv files in ADO	Guest (0)	Press F1

Post ID	Timestamp	Content	User
45682	2002-04-25 22:55:00	Hello there, I am in troubles again with VB. I am trying to load a *.csv file in an ADO recordset and I found all the necessary syntax on the web but my code is still not working. Is it because I need to specify a schema.ini; the data is separated by commas and I would have thaught there was no need for such a schema.ini file. The code is very simple: Public Function Read_Text_File() As ADODB.Recordset Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim conn As ADODB.Connection Set conn = New ADODB.Connection conn.Open 'DRIVER={Microsoft Text Driver (*.txt; *.csv)};' & _ 'Dbq=C:\marco;' & _ 'Extensions=asc,csv,tab,txt,att;' rs.Open 'SELECT * FROM Smith.txt, conn, adOpenStatic, adLockReadOnly, adCmdText' Set Read_Text_File = rs Set rs = Nothing Set conn = Nothing End Function Thanks a lot to everybody, Marco	Guest (0)
1