Select from a access table

I am looking for a way to select some data from a Access database into my 
SQL database.

In Enterprise manager, I want to do someting like:

SELECT InvoiceNo, CID
FROM c:\MyAccessDatabase.mdb\CIDTable
WHERE Im****ted=0