Reading an MS Access database from SQL SERVER is possible and quite simple.
SELECT * FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
Here the above SQL Query uses OPENDATASOURCE method to read the MS Access file .
1. 'Orders' is the name of the table in MS Access mdb file.
2. The 3 dots (...) should be there before specifiying the table name.
3. “Ad hoc distributed queries” has to be enabled to used the OPENDATASOURCE method.