Connect to text file using ADO?

[mike]

Is it possible to open an ADO connection to a comma-delimited text file?

If not, is there any other way to run a query on a comma-delimited text file
without actually importing the data to a table?

 

[Douglas J Steele]

Check what Carl Prothman has at
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForText and
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForTextFiles

 

[mike]

Thanks Douglas. The link was exactly what I needed.