Printing SQL query results in a list of columns, instead of one long column

R

romado33

I have a query that returns information on a bunch of construction jobs, but all the results of the SQL query are listed in one long column in Excel, while I need them in separate columns according to their job numbers. Is there any way to manipulate an SQL query display the results in multiple columns in Excel?

Thanks!
 
H

h2so4

After serious thinking [email protected] wrote :
I have a query that returns information on a bunch of construction jobs, but
all the results of the SQL query are listed in one long column in Excel,
while I need them in separate columns according to their job numbers. Is
there any way to manipulate an SQL query display the results in multiple
columns in Excel?

Thanks!
Click to expand...

2 possibles solutions

1) use text to columns in the data menu
2) use msquery to execute the SQL statement on your database
 
Top