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.
Lowell