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

Advertisements

H

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Single column to multiple columns 5
Access Determine what query to run based on a checkbox 0
How to display multiple IIf results in one column 1
column header needs symbol 2
print a long list with 2 columns 2
export MySQL to Excel? 7
Showing forumlae instead of results 3
How to display columns in the right order from a SQL DB query 4

Top