Home » RDBMS Server » Server Utilities » access tables to oracle
access tables to oracle [message #368312] Thu, 09 November 2000 00:23 Go to next message
Messages: 1
Registered: November 2000
Junior Member
does anyone know how to convert access tables to oracle data tables? and, once converted, how do i link to the oracle data tables with an access front-end? ODBC?
Re: access tables to oracle [message #368313 is a reply to message #368312] Thu, 09 November 2000 13:04 Go to previous messageGo to next message
Messages: 205
Registered: November 1999
Senior Member
Oracle Enterprise edition comes along with a database migration utility for ms access.
You can try that or you can manually create
tables in oracle, export data into text format from ms access, load the text data into oracle tables using oracle utility sqlloder.

For the second qestion, yes you have to use ODBC.

Re: access tables to oracle [message #368320 is a reply to message #368313] Fri, 10 November 2000 13:06 Go to previous message
Messages: 2
Registered: November 2000
Junior Member
The best way is to use ODBC. Create one using MS ODBC for Oracle. This way u can import, export and link oracle tables to MS Access. You can even export Access tables to Oracle via ODBC.

Good luck

Previous Topic: character set
Next Topic: SQL*Loder Problem
Goto Forum:

Current Time: Fri Nov 26 20:10:55 CST 2021