convert an ADO recordset to a text file that can be queried with SQL

R

RB Smissaert

Does somebody know a VBA routine that converts an ADO recordset to a text
file that can be queried with SQL.
I understand that this is possible. The text file will act as a table and
the field names of the recordset will the the table field names. I
understand that it is even possible to perform joins on different tables, in
this case different text files. This routine will run from Excel.
I posted to the ADO group as well, but perhaps there is more chance of an
answer in this group.
Thanks for any advice.

RBS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO recordset: Convert RTF field into plain text 0
Query 2 excel files with ADO 5
Retrieving Pipe (|) delimited text file into ADO Recordset 2
Problem creating PivotTable from ADO recordset using VBA 0
copy recordset to CSV file 1
ado command timeout property 0
Problem with query against CSV file using ADO 0
Use a persisted XML file as datasource 1

Top