How do I export a pass-through query to Excel. I know how to export an Access query using docmd.transferspreadsheet.
I'm passing select queries to Pervasive SQL. I'd like to be able to export the query results directly to Excel.
How do I export a pass-through query to Excel. I know how to export an Access query using docmd.transferspreadsheet.
I'm passing select queries to Pervasive SQL. I'd like to be able to export the query results directly to Excel.