| access tables to oracle [message #368312] |
Thu, 09 November 2000 00:23  |
octavious
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  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi,
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.
Bala.
|
|
|
|
| Re: access tables to oracle [message #368320 is a reply to message #368313] |
Fri, 10 November 2000 13:06 |
Oms
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
Oms
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
