Hello,
I am trying to use Microsoft Query to connect to my SQL Server instance to return a query result into my Excel workbook. Basically, i have a column of sql queries and then have a column titled "RESULT", which I'm using to return the result of my queries. I got it to work briefly, but as soon as I refreshed my results, my workbook goes crazy and starts inserting many random cells with the database connection that I created. I would also receive errors like "Failed because you cannot paste over a Pivot table" or something like that. I'm not sure what is happening?
My question is, what are the best practices for working with Microsoft Query for my specific need? What are the appropriate steps to return a specific result to an individual cell in Excel, rather than return an entire table?
Thank you,
J
Bookmarks