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
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.
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!