Re: SQR accessing Oracle & MS-Access tables

[Steven Calvert <calvert@ULETH.CA>]

Glenn:

You could use MS Access macros (or Visual Basic) to update the Oracle database
directly from the MS Access tables via ODBC. And, yes, this does avoid the use
of SQR completely ... which may not be the "proper" thing to suggest on an SQR
email list <grin>.

Just my .02,
Steve

"Ackerson, Glenn" wrote:

> Hi all,
>   I'm wondering if anyone else has written an SQR which accesses
> tables from both an Oracle database (Peoplesoft in this case) and
> a MS-Access database? At present, we have a Time & Attendance
> system that uses MS-Access, and we've created an interface that
> creates a flat file out of the Time system, which I subsequently use
> to update paysheets in Peoplesoft (via a heavily modified version of
> Peoplesoft's PAYUPDT program.) This process is working fine at
> present (I know, if it ain't broke, why fix it?), but I'm curious as to
> the possibility of having one program that would accomplish the
> interface without having to create the flat file. Anyone else done
> this? Does the version of MS-Access make a difference as far as
> SQL access from SQR is concerned? Thanks for your feedback.
>
> Regards,
> Glenn Ackerson
> **************************************************
> Glenn Ackerson
> Information Technology Professional III
> Internet Address: gsacker@is.unco.edu
> University of Northern Colorado
> Information Services
> Carter Hall   Greeley, CO  80639

--
Steven Calvert
calvert@uleth.ca
University of Lethbridge
(403)329-2071