Home » RDBMS Server » Server Utilities » loading from other applications
loading from other applications [message #191983] Sat, 09 September 2006 10:09 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
hi!
how can I, LOAD DATA FROM ACCEESS USING SQL LOADER.
Re: loading from other applications [message #191984 is a reply to message #191983] Sat, 09 September 2006 10:30 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Only if the data is extracted to flat files first.
Re: loading from other applications [message #192026 is a reply to message #191984] Sat, 09 September 2006 21:44 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Depending on the data volumes, it might be better to use an ODBC Link Table to insert the data directly from Access. If this is too slow, then look into SQL*Loader.

Ross Leishman
Re: loading from other applications [message #192279 is a reply to message #191983] Mon, 11 September 2006 12:14 Go to previous message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

Hi,

The data from access to flat file, text file, excel to csv file make and from there you can use sql*loader.

Thanks,

Mohan Reddy
Previous Topic: loading by sysdba
Next Topic: What does the Buffer imply in the Import and Export ?
Goto Forum:
  


Current Time: Fri Dec 02 20:48:42 CST 2016

Total time taken to generate the page: 0.13330 seconds