Query results in Excel
Looking for a way to copy SQL query results from SQL management grid into Excel. My results are wrapping around in excel.
Any inputs will be appreciated
Any inputs will be appreciated
ASKER
Is there a better way to get the results into excel besides selecting all and pasting in Excel
OK, understood now. Thanks.
If you execute your SQL through a GUI based tool then most GUIs have an "export" capability.
What tool do you use to execute your SQL queries?
If you execute your SQL through a GUI based tool then most GUIs have an "export" capability.
What tool do you use to execute your SQL queries?
ASKER
SQL Management
Would this be a regularly scheduled thing (which would lean to an SSIS scheduled by SQL Server Agent solution), or a user with an Excel spreadsheet wanting to pull data from SQL Server (Excel connection)?
The article Microsoft Excel & SQL Server: Self service BI to give users the data they want is a full demo of how within Excel you can connect to SQL Server and execute a specific Stored Procedure, which populates the Excel spreadsheet.
The article Microsoft Excel & SQL Server: Self service BI to give users the data they want is a full demo of how within Excel you can connect to SQL Server and execute a specific Stored Procedure, which populates the Excel spreadsheet.
ASKER
1 time. I use SSIS a lot and tried using it here to push the data into excel. I am getting Unicode errors. I added data conversion and getting "data conversion is not mapped to an upstream" error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have a comment column in col B (all kinds of data in this column) that is wrapping around into cola.
Not sure what you are wanting from us. e.g. A macro to fix the Excel format?