sql to excel????

[DirtDawg]

Hello all

I have some sql tables table1 to table7. All of the tables have identical columns and rows. What I would like to do is write a macro that will take comments from each of the 7 tables and merge the data into one cell on a spreadsheet?

any help would be great.

Table layout(below)
id name product sales comments
1
2
3
4
5
6
7
8
9
10

 

[PHV]

Have you tried to play with the menu Data -> External data ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkipVought]

...and Edit the SQL as such...

Select Sheet1.Comments
From 'C:\....\YourWorkbook.xls'.'Sheet1'
Union
Select Sheet2.Comments
From 'C:\....\YourWorkbook.xls'.'Sheet2'
Union
...etc

:-0

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}