OraFAQ Forum: Programming Interfaces » How to load the data into tables

Home » Open Source » Programming Interfaces » How to load the data into tables (Oracle9i,Windows)

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

How to load the data into tables [message #322830]

Mon, 26 May 2008 06:32

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.

Report message to a moderator

Re: How to load the data into tables [message #322833 is a reply to message #322830]

Mon, 26 May 2008 06:45

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Create a ODBC DSN and write a VBA program, for instance.

Regards
Michel

Report message to a moderator

Re: How to load the data into tables [message #322835 is a reply to message #322830]

Mon, 26 May 2008 06:46

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: How to load the data into tables [message #322844 is a reply to message #322833]

Mon, 26 May 2008 07:06

sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai

Senior Member

Hi,

Can u give link regarding this.

Thanks,
Michael.

Report message to a moderator

Re: How to load the data into tables [message #322845 is a reply to message #322835]

Mon, 26 May 2008 07:08

sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai

Senior Member

hi,

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

Thanks,
Michael.

Report message to a moderator

Re: How to load the data into tables [message #322851 is a reply to message #322845]

Mon, 26 May 2008 07:22

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to load the data into tables [message #322853 is a reply to message #322851]

Mon, 26 May 2008 07:31

sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai

Senior Member

Ok thanks ..

Can u give link for data loading using ODBC?

Thanks,
Michael.

Report message to a moderator

Re: How to load the data into tables [message #322855 is a reply to message #322853]

Mon, 26 May 2008 07:47

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 05:03:16 CST 2024