Re: MSAccess to Oracle7 Conversion

Alexander Moan wrote:
>
> 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 !" |
> ---------------------------------------------------------

Alex,

        The Tables and data are the easy part of this conversion. It's the queries and macros that are giving us the headaches. We can convert manually, however there are approximately 900 queries, and very little time to do the conversion... Again, ANY help/info for an automated MS access to Oracle upsizing conversion would be greatly appreciated.

Doug Baird Received on Wed Aug 14 1996 - 00:00:00 CEST