Export SQL data to Excel into specific columns?
Posted: 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
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