How can I query data from a table in Ms Access in a SQL Server 2005 stored procedure?

Question

How can I query data from a table in Ms Access in a SQL Server 2005 stored procedure?

Answer 1

Syntax example here

SELECT * FROM 
OpenDataSource( 
    'Microsoft.Jet.OLEDB.4.0', 
    'Data Source="c:\temp\payroll.mdb";
    User ID=Admin;Password=;')...employees

I think that Microsoft.ACE.OLEDB.12.0or Microsoft.ACE.OLEDB.14.0may be preferable to Jet.