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

  • Thread starter Thread starter romado33
  • Start date Start date
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!
 
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!
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
 
Back
Top