Home » Open Source » Programming Interfaces » How to load the data into tables (Oracle9i,Windows)
How to load the data into tables [message #322830] Mon, 26 May 2008 06:32 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

How to load the data into tables from excel sheet into oracle database using ODBC.

Thanks,
Michael.
Re: How to load the data into tables [message #322833 is a reply to message #322830] Mon, 26 May 2008 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a ODBC DSN and write a VBA program, for instance.

Regards
Michel
Re: How to load the data into tables [message #322835 is a reply to message #322830] Mon, 26 May 2008 06:46 Go to previous messageGo to next message
Littlefoot
Messages: 19697
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Using ODBC? I wouldn't know.

But you could always save Excel Worksheet as a CSV file and load it into an Oracle table using SQL*Loader or, if your database version supports it, use it as an external table.
Re: How to load the data into tables [message #322844 is a reply to message #322833] Mon, 26 May 2008 07:06 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

Can u give link regarding this.

Thanks,
Michael.
Re: How to load the data into tables [message #322845 is a reply to message #322835] Mon, 26 May 2008 07:08 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
hi,

Using ODBC is faster than others.So i need it.

Thanks,
Michael.
Re: How to load the data into tables [message #322851 is a reply to message #322845] Mon, 26 May 2008 07:22 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Using ODBC is faster than others.

This is wrong.
Using SQL*Loader or external table is the fastest way as soon as there are more than a couple of hundreds of rows.

Regards
Michel
Re: How to load the data into tables [message #322853 is a reply to message #322851] Mon, 26 May 2008 07:31 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Ok thanks ..

Can u give link for data loading using ODBC?


Thanks,
Michael.
Re: How to load the data into tables [message #322855 is a reply to message #322853] Mon, 26 May 2008 07:47 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Is google broken for you by any chance ? I got this link in the very first page of google.

http://www.oracle.com/technology/products/warehouse/pdf/Cases/case3.pdf

Regards

Raj
Previous Topic: Number field getting truncated for german locale via oracle obdc 10g driver
Next Topic: Need information for Transparent Gateway for SQL Server
Goto Forum:
  


Current Time: Sat Oct 25 04:10:02 CDT 2014

Total time taken to generate the page: 0.16157 seconds