SQL Stored Procedure + MS-Access

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.

All Forums

Other Forums

MS Access

SQL Stored Procedure + MS-Access

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-01-09 : 08:30:47

srinivas writes "hi
1. MS-Access database having one table
2. How to access the MS-Access database table from Sql Server Stored Procedure? is it possible or not ?
3. if possible then give the solution...
4. if it is not possible then pls..give the alternative solution...

thanks and regards
srinivas thottempudi"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-09 : 08:40:28

Possible if you make use of Linked Server or OpenRowset
From BOL

SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
        'c:\MSOffice\Access\Samples\Northwind.mdb';'Admin';'';
        Employees)

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources