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 |
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
 Posted - 2001-12-17 : 10:54:57
|
| Is it possible to write a stored procedure where you will be able to open the access database and read the data from that ?rita |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2001-12-17 : 11:09:30
|
| Sure, set up a linked server to the Access database and use 4-part naming to write statements against it. |
 |
|
|
|
|
|
Opening Access database from sql stored procedure