Re: Oracle to access

From: Dave Keene <davek_at_xetron.com>
Date: 1997/02/21
Message-ID: <01bc202b$3f7bece0$e014e481_at_davek.xetron.com>#1/1

Doug Lane <app1del_at_is.ups.com> wrote in article <330DDD84.29F6_at_is.ups.com>...
> Is there any way to easily pull data from an Oracle db...

Yes. Make sure that you have the Oracle ODBC driver installed on your PC workstation. From your Access database, with the database window in focus, do File/Get External Data/Link tables...; near the bottom of the dialog window is a pull-down list labeled "Files of type ...". Select "ODBC Databases", and in the resulting dialog specify your Oracle database. You will then be able to create table links to the Oracle tables. You may then construct insert or create table queries from the linked tables. When you get to be familiar with the process, you can skip the query step by doing File/Get External Data/Import... and following much the same procedure. Received on Fri Feb 21 1997 - 00:00:00 CET

This message: [ Message body ]
Next message: Good Friend: "Learn to Make $$$FAST CASH$$$ With Honest Work"
Previous message: Doug Lane: "Oracle to access"
In reply to: Doug Lane: "Oracle to access"
Next in thread: mike: "Re: Oracle to access"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message