Forum Discussion
Use query results in another excel sheet.
Dear all,
I do hope you can help me with this.
I have a query with more than 300.000 rows (I know they are too much, but this is..)
My first willing would have been to export them in an excel sheet and use the table in another workbook for more analysis.
I am wondering if it is possible to use the query result in another excel workbook without loading them in an excel table.
Thanks.
Hi Mic1979 ,
According to your description, you can connect directly to the data source but not load the table, and after you fetch the data, you can choose to create a connection only to fetch the data without loading itBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
5 Replies
use the query result in another excel workbook without loading them in an excel tableuse them how? What are you trying to achieve?
A simple way is create two different queires in two different file and refresh them separately.
there is a way to export part of your query into another fuile but I do not recomend it due to some of its drawback.Hi Mic1979 ,
According to your description, you can connect directly to the data source but not load the table, and after you fetch the data, you can choose to create a connection only to fetch the data without loading itBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
