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

[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!

 

[h2so4]

After serious thinking (e-mail address removed) 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!

2 possibles solutions

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