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
 

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
Changing column reference for number of formulas at once 1
Access Determine what query to run based on a checkbox 0
Moving a bunch of data 1
How to create a column of pseudo random numbers with probability ' 2
print a long list with 2 columns 2
Showing forumlae instead of results 3
How to display multiple IIf results in one column 1

Back
Top