[AccessD] Pull Data From Oracle Into Access XP

Jim Lawrence accessd at shaw.ca
Tue Jan 18 21:05:31 CST 2005


Hi Dan:

It sure can. You have to use an ADO connection, send a SQL query through the
connection and retrieve and process the results through a recordset. It is
not difficult. If you need some code send all a request.

HTH
Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Tuesday, January 18, 2005 12:36 PM
To: Database Advisors
Subject: [AccessD] Pull Data From Oracle Into Access XP

I have an application where I need to routinely look up information in an
Oracle database.  Can this be done without pulling the entire contents of
the table (or tables) into Access each time?

 

Thanks,

Dan Waters

ProMation Systems        

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list