Re: Oracle import from Access

From: <scrusea_at_my-dejanews.com>
Date: Mon, 18 May 1998 20:29:07 GMT
Message-ID: <6jq5mi$5gg$1@nnrp1.dejanews.com>

In article <35614ed4.5628873_at_news-reader.bt.net>, majeed_at_softopt.co.uk wrote:
>
> Hi
>
> Is it possible to import an access .mdb into oracle
>
> Thankz
>

The way I would go and have gone in the past is to export the Access data table by table to the Oracle database desired. This has to be done via ODBC as an Save As/Export option, choose the external database option, then ODBC choose oracle data source that has been preconfigured and the table will be created.

Good Luck.

Anthony Scruse

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 18 1998 - 15:29:07 CDT