Re: populate Oracle from Access

Bruce,
Since you have only a few thousand rows, you can use Access's SQL to insert the data into the Oracle tables, after the latter have been attached ("linked"), which requires you first to have created an ODBC DSN. The Access SQL insert statement can incorporate user-defined and Access intrinsic functions if you should need to do any data cleanup during the upload process. I would first build an Access query that incorporates any such cleanup, and which has the columns in the order that mirrors the Oracle table's structure, and then I'd insert into the Oracle table through the intermediary of the (saved) Access query (which is like an Oracle view).  Tim Romano

Brian Lavender wrote:

> Get yourself a copy of perl ported for windoze. Read through Jeff's
> examples. That should get you going. You can talk to access and oracle
> simultaneously. This way you can massage the data if you need to when
> making the transition. I have a copy script at work. If you need more
> info I can post that once I go back to work.
>
> brian
> --------------------
> Brian Lavender
> Sacramento, CA
> http://www.brie.com/brian/
>
> "If a train station is where the train stops,
> what is a workstation?" -- Phil Adamson
>
> Jeff Urlwins DBI example page
> http://www.access.digex.net/~jurlwin/
>
> perl for win32 (Gurusamy Port)
> ftp://ftp.archive.de.uu.net/pub/CPAN/ports/win95/Standard/x86/perl5.00402-bindist04-bc.tar.gz
>
> On Mon, 28 Dec 1998 12:01:12 GMT, clarkb_at_scmb.co.za wrote:
>
> >Hi Gurus,
> >
> >Is there a way to populate Oracle (ver 7) from an existing Access Database ?
> >The Access base that I need to move accross has a few thousand records. I need
> >a simple way to transfer the required fields. Any help would be greatly
> >appreciated.
> >
> >TIA.
> >
> >Bruce.
> >
> >-----------== Posted via Deja News, The Discussion Network ==----------
> >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Jan 04 1999 - 09:33:44 CST