Export SQL data to Excel into specific columns?

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Tony414
Posts: 1
Joined: Thu 25 Apr 2013 16:54

Export SQL data to Excel into specific columns?

Post by Tony414 » Thu 25 Apr 2013 17:02

Hello,
I am new to this forum and know very little in SQL. Here is what I am trying to figure out and I'm not sure if any of Devart's software will work for me.

I need to extract data from my SQL server and output it to an Excel file. The big question is that I need to be able to place the data into specific columns. I currently have an SQL script now that exports it to a CSV file but the data is just in sequential order(column A, B, C etc)

If this can be done it would be great to get some guidence on this. Thanks in advance :)

Tony

alexa

Re: Export SQL data to Excel into specific columns?

Post by alexa » Sat 27 Apr 2013 14:54

You can export data into the Excel, CSV, etc files, however, you can not perform this with specific cells. Please refer to the 'Data Export Wizard' topic in the product's Help documentation for details.

Post Reply