read data from an ODBC data base [message #365484] |
Tue, 30 June 1998 08:11 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Joerg Hildebrandt
Messages: 1 Registered: June 1998
|
Junior Member |
|
|
I have an 'old' data base witch can be read with the DataFlex ODBC driver (for instance into Access). Witch tool of Oracle 8 can read this ODBC data to load it into my created Oracle structure? I read something about the SQL* Loader but it seems to me that this tool can only work with ASCII files?!
Thanks in advance.
|
|
|
|
Re: read data from an ODBC data base [message #365606 is a reply to message #365484] |
Sat, 06 March 1999 19:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Bob
Messages: 49 Registered: March 1999
|
Member |
|
|
There is an Access Tool to Convert Access tables to Oracle tables. It requires no effort at all.
I can't remember the name of it right now, but it is much easier than dealing with the oracle loader. Check for a download at microsoft.com
|
|
|
|
Re: read data from an ODBC data base [message #365721 is a reply to message #365606] |
Thu, 11 November 1999 08:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Joe
Messages: 138 Registered: November 1999
|
Senior Member |
|
|
Hi.. i'm a dummy in Oracle..but recently i'd been ask by someone to convert a oracle *.ora table to MS Acess table. i got no idea.. i installed the Oracle 8.05 Server i tried to connect using ODBC.. but failed.. itz asking for service name and password.. as far as i lknow i didn't setup n e password for that.. kindly guide me.. PLEASE
|
|
|