I 've used below query from query analyser, its working fine.

SELECT a.*

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'c:\MSOffice\Access\Samples\northwind.mdb';'admin';'mypwd', Orders)

AS a