converting access database

[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?

 

[Jeff Boyce]

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?

 

[jon mich via AccessMonster.com]

I just want to import the data from my access database to oracle

 

[Duane Hookom]

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.

 

[Lynn Trapp]

What version of the Oracle database are you using?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Jeff Boyce]

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 Trapp]

Jeff,
If he is on Oracle 9i database there is an even easier way -- or at least a
way that his DBA's would probably be more comfortable with than using ODBC,
but he would have to do it on the Oracle side.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Jeff Boyce]

Lynn

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

Jeff