Uploading data from Oracle to MS Access

[Rajesh Candamourty]

Dear all,
I have an Access database and an Oracle database. Some of
the tables and fields are common on both. The Oracle
database is administered by the Corporate and the Access
database at the manufacturing plant.
I would appreciate any sort of information to find out how
to upload some data of some fields/table from the Oracle
database and put it into the MS Access database of some
specified field/table?
What are the things I should do for this.

Thank you.
Rajesh Candamourty

 

[John Conklin]

You would need an ODBC connection to the Oracle Database, and then link the
tables in your Access Database.

You can then create some queries to pull whatever data you need from the
Oracle tables and put it into a local Access table.

~John

 

[Rajesh Candamourty]

-----Original Message-----
You would need an ODBC connection to the Oracle Database, and then link the
tables in your Access Database.

You can then create some queries to pull whatever data you need from the
Oracle tables and put it into a local Access table.

~John




.

Thanks for your reply John,
But the DBA would not give me a link or an ODBC connection
for security purposes.
I want something other than this.
I appreciate any help.

Thank you.
Rajesh

 

[Lynn Trapp]

What kind of security is your DBA worried about? You would still have to log
on to the Oracle Database with a valid user name and password. Ask your DBA
to create a read only View that you can link to and update your Access
database with that.