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-06-29 : 11:42:28
|
| Paul writes "I am a newbie in SQL development. My question is how to create a table in SQL 2000 which can be real time linked to a Excel worksheet, so that user can edit, add or delete data either at the Excel worksheet or directly to the SQL table. All the changes can be refreshed instantly on either locations. Basically I want the SQL 2000 as the back end/data storage of an application, the end user will use Excel for data entry or they can build pivot table for data analysis, also I will build an Access front end for data reporting only. I know how to link SQL 2000 to Access using ODBC but I have not had a clue on how to link SQL 2000 to Excel." |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-06-29 : 19:22:33
|
| Did you post a similar question recently? Looks very familiar.There's a few options for your predicament (in order of my preference):1. Use SQL's Linked Servers to link the spreadsheet to the database (see Books Online under Linked Servers for more info)2. Use a DDE (Dynamic Data Exchange) link b/w your Access front end and the Excel s/s (see Access's help files under DDE)3. Build macros into your spreadsheet to read/write the data between the database and Excel.HTH,Tim |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-06-29 : 19:26:10
|
| Why not just use an Access Data Project instead of Excel to do your data entry?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
Real time link from SQL 2000 to Excel XP