Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leitethomas26
Starting Member
1 Post |
 Posted - 2009-03-28 : 16:25:01
|
| HiI have a simple database in SQL Server 2005...I made a simple query like this....Select CitiesName,CitiesSizeFrom CitiesI save this query.......Now i want to run it from excell 2003 or 2007.... I mean the 2 columns that query brings(Cities_Name, Cities_Size) bring it in excell file....I know that i can input data in Excell from a Table... But can i input data from a query???????????? Because my table have many fields and i want only these 2.... Is there any other way????Thanks in advance |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-03-28 : 16:57:32
|
| you can do it. Look for Madhivanan's famous post[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926[/url] |
 |
|
|
|
|
|
SQL Server 2005,Query,Output Data to Excell