OraFAQ Forum: Windows » read data from an ODBC data base

Home » Infrastructure » Windows » read data from an ODBC data base

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

read data from an ODBC data base [message #365484]

Tue, 30 June 1998 08:11

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.

Report message to a moderator

Re: read data from an ODBC data base [message #365486 is a reply to message #365484]

Tue, 30 June 1998 11:12

Sarvesh
Messages: 7
Registered: June 1998

Junior Member

Try creating an ASCII text file from your OLD database. Then use SQL*LOADER to load this into ORACLE database.

Report message to a moderator

Re: read data from an ODBC data base [message #365606 is a reply to message #365484]

Sat, 06 March 1999 19:44

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

Report message to a moderator

Re: read data from an ODBC data base [message #365675 is a reply to message #365484]

Thu, 10 June 1999 14:27

Fco Márquez Castillo
Messages: 1
Registered: June 1999

Junior Member

Please send Me files with odbc for Oracle for connect with VisualDataflex 5.0

Fco M�rquez

Report message to a moderator

Re: read data from an ODBC data base [message #365721 is a reply to message #365606]

Thu, 11 November 1999 08:48

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

Report message to a moderator

Previous Topic:	automated oracle installation on nt
Next Topic:	queries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 12:05:29 CDT 2025