Re: Exporting Access data/import to Oracle

bmolish_at_my-dejanews.com wrote:

>
>
>
>Has anyone exported an Access database and imported into an Oracle database?
>We currently are using Oracle 7.3.2 on an HP UX box.
>We are also using Access 97...
>
>
>Could you please provide me with the step and any usefull information.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

Use the Save As/Export option while highlighting the table you want to export....Choose External ....Select your Oracle ODBC connection and go to it...

If you don't have ODBC set up for Oracle and don't have SqlNet installed,. this obviously won't work....In the alternative, you can export the Access Table data as a comma-delimited file and use SqlLoader to load it into Oracle. Received on Thu Jun 04 1998 - 00:00:00 CDT