Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert an ADO recordset to a text file that can be queried with SQL
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
how do I convert an excel file to a flat text file | Excel Discussion (Misc queries) | |||
Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
create recordset from csv file on web | Excel Programming | |||
Recordset Opening Excel File | Excel Programming |