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 Imported=0

Look into creating a linked server from the Access MDB to the SQL
Server instance.

Here's a useful link on the subject:
http://www.aspfree.com/c/a/Microsoft...L-2005-Server/

-Eric Isaacs

Please do not multipost, replied in comp.databases.ms-sqlserver. Copy/paste
here:

Create a linked server using the OLE DB Provider for Jet and then you can
query all Access tables:
http://msdn.microsoft.com/en-us/libr...7(SQL.80).aspx

HTH,

Plamen Ratchev
http://www.SQLStudio.com