[AccessD] Pull Data From Oracle Into Access XP

Or you can link the Oracle Tables in as Access tables via ODBC and do
regular queries against them too. If you have criteria to go for a
specific record or set of records the entire Oracle table won't be
pulled. The performance is pretty good - depending on how specific
your criteria are. .


On Tue, 18 Jan 2005 22:24:40 -0600, Dan Waters <dwaters at usinternet.com> wrote:
> Thanks Jim!  Your example code would be a great help.
> 
> Is this an example of a pass-through query?
> 
> Dan
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
> Sent: Tuesday, January 18, 2005 9:06 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] Pull Data From Oracle Into Access XP
> 
> 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
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
Gary Kjos
garykjos at gmail.com