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 |
|
Richard Branson
Yak Posting Veteran
84 Posts |
 Posted - 2004-02-12 : 09:00:13
|
| HiI want to find out if there's a way i can retrive data from a SQL server and manipulate it using excel. i don't want the result data to be raw data I want Proceesed data like distinct counts, sums, averages and stuff like that without me lifting a finger.AlternativelyI would like to retrieve and process the data in SQL and then dump it into excelany sp_ that I can use????You can't teach an old mouse new clicks. |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-02-12 : 09:21:42
|
| Since Excel can open HTML Documents, it might work if you try sp_runwebtask and sp_makewebtask - see books online |
 |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-02-12 : 10:10:17
|
quote:
without me lifting a finger
Who wouldn't like to work like that. Unfortunately, the best way to get data in XLS from SQL is to pull it out using the "Get external data" function in Excell. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-02-12 : 22:37:21
|
| Don't know what's so unfortunate about that, it's very handy and easy to use. Only downside is it requires a live connection to the database to refresh it.Another option is to use DTS to transfer directly to Excel format, OR...use DTS or bcp to export to tab-delimited format. If you output to tab-delimited but name the file with a .XLS extension, Excel will automatically open it and convert it.Books Online can tell you more about bcp and DTS. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-02-13 : 01:14:59
|
| Another option is Crystal reports or Active reports. I think both have an Excel export option.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
SQL to Excel