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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-27 : 09:06:04
|
| Enrique writes "Well, I try to access the data located in a remote Sql Server DB from Excel. I mean, I'd like to execute a query from an Excel sheet against a Sql Server 2000 database. ¿Could you help? Thanks a lot." |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-09-27 : 09:51:45
|
| In EXCEL....(v97 anyway)...on the DATA menu option, select "GET External Data", then "Create New Query"...and follow the prompts....once you've saved the query, you can follow a smiliar path to re-use the query in another spreadsheet. |
 |
|
|
|
|
|
¿How to access data from Excel?