ansaurus

Question

Answer 1

+1 A:

Example syntax from here

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

I think Microsoft.ACE.OLEDB.12.0 or Microsoft.ACE.OLEDB.14.0 might be preferred to Jet though.

Martin Smith 2010-08-18 19:29:43

Which is preferable depends on the format of the data file. If it's MDB, you need to use Jet, no matter what version.

David-W-Fenton 2010-08-19 18:06:53

How can i query data from a table in Ms Access in my SQL server 2005 stored procedure ?