This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 27%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPO%3C/text%3E%3C/svg%3E)
Is there a way to return an ADO.Recordset into Excel from a Workbook.QueryTable ?
I know how to create a ListObject with its Querytable, which necessarily means dumping all the data on to a worksheet. I'd like a Recordset in-memory.
An implementation of Visual Basic that is built into Microsoft products.
Tag not monitored by Microsoft.
Hi @Patrick O'Beirne ,
Tag "office-excel-itpro" focuses on general issues about Excel clients.
Since your issue is more related to connection string and Data Source which are out of our scope of support. I would remove the tag “office-excel-itpro”.
Thanks for your understanding.
My question is "Is there a way to return an ADO.Recordset into Excel from a Workbook.QueryTable ?"
Which is why I asked about Excel.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 82%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPO%3C/text%3E%3C/svg%3E)
Excuse me emizhang I should also have asked
Is there a support forum here more related to connection string and Data Source ?
Thank you Inbar, that answers the question.
I wonder, will we some day be able to connect to the Data Model in VBA?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIP%3C/text%3E%3C/svg%3E)
Hi @Patrick O'Beirne , to quote one of our Excel specialists:
A power query table is not a source that one can connect to, it is a transient entity that acts as an intermediary between a source and a query table in Excel or between a source and the Excel/Power Pivot data model.
This means that there is no way to connect directly to a Power Query table, only to the persistent result of the query in a query table or in the model.