| urgent [message #52420] |
Fri, 19 July 2002 20:39  |
akularaju
Messages: 6
Registered: July 2002
|
Junior Member |
|
|
Hi,
I would like to know how to use sql*connect or oracle open gateway if I want to read the data from MS-Acess or from some textfile etc.Is there any programming for it or configuring?Please help me
thanx
|
|
|
|
| Re: urgent [message #52421 is a reply to message #52420] |
Fri, 19 July 2002 21:07  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
Hi,
if u want to read data from Text file u can use SQL*Loader / UTL_FILE Package (Read Documentation for syntaxes) available from ORACLE 8.05.. incase u want to read Data from Ms.Access u will have to create a ODBC driver then by getting into MSACCESS, Right click on the Table..and then say export..by passing the username and password details..u will be able to migrate the data from Access to ORACLE...
Bye
sai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
