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 - 2002-05-28 : 08:42:08
|
| Eric Viksnins writes "Hi there,I'm trying to pull MS SQL table values into Excel using DDE so that the spreadsheet will essentially show real time data. Using dde, the spreadsheet will update every time the sql table is changed. Do you know if DDE can be used with MS SQL? Any help would be greatly appreciated. I can't find info on this anywhere!" |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-05-28 : 09:02:24
|
| Yes you can connect to SQL Server thru Excel (not sure if this is actually DDE or another method).From Excel 2000... Click "Data", choose "Get External Data", choose "New Database Query". The "Choose Data Source" dialog box will appear. <New Data Source> should be the first item on the list and probably already selected, click "OK". The "Create New Data Source" dialog box will be displayed. The first line assigns a name to your source, the second line is a drop down to select the data source driver; in the list you will see SQL Server. Complete the rest of the dialog box with the requisite data.hth,Justin |
 |
|
|
|
|
|
dde