Access has linked servers?

i think i just read your question wrong.

If you've correctly set up an Oracle Linked server, you can first use sp_tables_ex MyOracle and you should see a list of some tables.

You posted in a SQL server web site, and talked about Linked servers, which are in SQL server as well....

after that, it's going to require specifics concerning the data there, but it would look something like this:

--list all the tables and their names

EXEC sp_tables_ex MyOracle

GO

select * from MyOracle..SCOTT.EMP

select * from MyOracle..USERNAME.TABLENAME

select * from MyOracle..MFHDS.GMACT

From SQl Server,

Access linked servers look almost exactly the same, but with no user

EXEC sp_tables_ex MyAccess

select * from MyAccess...Invoices;

however, I have not gotten a 64 bit Access Linked server to work yet; as far as i know the ACE driver is broken as far as Access, but works for Excel.