Re: Loading data from Access to Oracle?

Steve Corbett wrote:
>
> Scott Siedler wrote:
> >
> > Is there a way of reading MS*Access data (*.dbf) into Oracle tables? Are
> > there any tools on the market that are made for getting data from other
> > vendors' databases into Oracle? Any help or suggestions would be greatly
> > appreciated.
> >
> > Scott
>
> i asked this question awhile ago - no response
> you could have at least acknowledged my typo *.dbf instead of *.mdb :)
>
> steve.

[Quoted] [Quoted] Here's one way to do it.(MS-Access 2.0)

Launch Access.
Open desired database.
From the File menu choose Export
Choose SQL Database from Data destination list Choose desired table
Specify table name for ORACLE (case sensitive) Choose Oracle database to load to (assuming you have an ODBC connection to the ORACLE db)
[Quoted] Login to ORACLE

and that's it. Received on Fri May 16 1997 - 00:00:00 CEST