Re: MSAccess to Oracle7 Conversion

In the article <3210E09E.18F_at_worldnet.att.net>, dbaird <dbaird_at_worldnet.att.net> wrote :
> I'm looking for a tool(s) to help in the conversion of a Large MSAccess
> database to Oracle7. ANY help/info would be GREATLY appreciated!
> (Having specific problems with Queries within MSAccess).
>
>
> Doug B.

Hi dough !
We are using access 2.0 constantly as a kind of front end to oracle for variuos reasons.
As I haven't yet seen any super-duper-export-import-utility to do this on the fly, you have roughly two possible solutions :

1. Use ODBC directly from Access to gain direct access to Oracle. This is what we have done. Works fine !
2. Export all relevant data from access to some delimited or fixed record file format, and use oracle import utility to load the data into oracle. I haven't tried this myself, but it should be fairly straight forward.

In either cases you may have to create the tables in oracle manually to ascertain right column formats.

Hope this is of some help.

--
----------------------------------------------------------
| Alexander Moan	 --:-)		      moan_at_sn.no |
| Any statements I make are my own, and are not to be    |
| taken as an statement from my employer.                |
|                                                        |
| Norwgian Defence Command Norway			 |
| Home Guard Staff					 |
|							 |
| "Don't blame me, I just work here !"			 |
---------------------------------------------------------