OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » XL File import

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

XL File import [message #152683]

Mon, 26 December 2005 07:10

dskcheck
Messages: 6
Registered: December 2005
Location: Dubai

Junior Member

hi,

Can some one tell me about, how can i import values from any given XL file to a specific Table?

I'm using oracle 9i database and windows xp along with office 2003.

I have 3 columns in my XL file and 3 Fields in my table.

Thanks for reading my message.

Report message to a moderator

Re: XL File import [message #152684 is a reply to message #152683]

Mon, 26 December 2005 07:18

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

By 'XL file' do you mean an 'Excel File'?
Using improper/self-framed abbreviations is not so welcomed when you speak technically.
You can use sqlldr.
Search this forum for sqlldr/sql*loader.
You get many hits.
http://www.orafaq.com/faq/sql_loader

Report message to a moderator

Re: XL File import [message #152685 is a reply to message #152684]

Mon, 26 December 2005 07:20

dskcheck
Messages: 6
Registered: December 2005
Location: Dubai

Junior Member

Thank you Mahesh. As a matter of fact, i'm a novice and hence forth will follow your advice...

Report message to a moderator

Previous Topic:	Sequence while loading through SQL*Loader
Next Topic:	Dose Oracle lock the table during exporting (EXP)?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 06:18:08 CST 2024