Can I access MS Access table in a select query of SQL Server

Is there a way to specify a MS Access table (or query object) in the select query of SQL Server.

Ex.:

MSAccessTable (in file.mdb)

col1

col2

a1

a2

b1

b2

SQL query in SQL Server:

SELECT col1, col2 into SqlTable from [file.mdb].MSAccessTable;

Thanks,

Have a look at OPENROWSET in Books online

This is the direct link for your local BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/f47eda43-33aa-454d-840a-bb15a031ca17.htm

|||or BOL for OPENROWSET at http://msdn2.microsoft.com/en-us/library/ms190312.aspx