converting access database

  • Thread starter Thread starter jon mich via AccessMonster.com
  • Start date Start date
J

jon mich via AccessMonster.com

I have to convert an access database to an oracle database.
Does someone has tips or can someone tell me how to do that?
 
Does Oracle have a "data transform" feature? MS SQL-Server has a "DTS"
(data transform... service) you can use to import the data structure from
Access.

Are you trying to import data only, or are you looking for a way to import
the entire application?
 
With SQL Server (and other "targets"), you could create an ODBC datasource
for the target database/catalog and then export your table(s) to the ODBC
datasource name.
 
Create a link to the Oracle tables from within the Access db using ODBC.
Create append queries to take data from the Access tables to put in the
Oracle tables.
 
Lynn

I suspected as much, but couldn't speak knowledgeably -- and I know the
"push" could work.

Jeff
 
Back
Top