OraFAQ Forum: Server Utilities » import and export

Home » RDBMS Server » Server Utilities » import and export

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

import and export [message #228105]

Sat, 31 March 2007 13:37

SUSAN1
Messages: 36
Registered: March 2007

Member

hi,
how can I import data from a excl/textfile to my database?
the attache file is an example of the kind data that I need to import to my database.

[Updated on: Sat, 31 March 2007 13:45]

Report message to a moderator

Re: import and export [message #228107 is a reply to message #228105]

Sat, 31 March 2007 13:45

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Save Excel file as CSV file and load it using either SQL*Loader utility or external table feature.

Report message to a moderator

Re: import and export [message #228108 is a reply to message #228105]

Sat, 31 March 2007 13:46

SUSAN1
Messages: 36
Registered: March 2007

Member

thank you

Report message to a moderator

Re: import and export [message #228110 is a reply to message #228105]

Sat, 31 March 2007 13:53

SUSAN1
Messages: 36
Registered: March 2007

Member

you know I am not sure that understand what you mean can you please excplaine it clearly.
thanks/Susan

Report message to a moderator

Re: import and export [message #228123 is a reply to message #228110]

Sat, 31 March 2007 23:46

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Littlefoot show you how can you load textfile,csv etc files in database through SQL*LOADER or EXTERNAL TABLE option.

you should try to search example on orafaq.com >>>look

http://www.orafaq.com/forum/?SQ=55184afb1fba9d2d7d0b5c7c90a4f352&t=search&srch=SQL*LOADER&btn_submit=Search&field=all &forum_limiter=&search_logic=AND&sort_order=DESC&author=

or

http://www.orafaq.com/forum/?SQ=55184afb1fba9d2d7d0b5c7c90a4f352&t=search&srch=EXTERNAL+TABLE&btn_submit=Search&field =all&forum_limiter=&search_logic=AND&sort_order=DESC&author=

Regards
Taj

Report message to a moderator

Re: import and export [message #228152 is a reply to message #228105]

Sun, 01 April 2007 15:31

SUSAN1
Messages: 36
Registered: March 2007

Member

thanks,
but I wonder if I want load textfiler in SQL server is the same as Oracle?

Report message to a moderator

Re: import and export [message #228154 is a reply to message #228105]

Sun, 01 April 2007 15:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>but I wonder if I want load textfiler in SQL server is the same as Oracle?
HUH?
Please restate your question & why are you mentioning SQL Server in an Oracle forum?

Report message to a moderator

Re: import and export [message #228666 is a reply to message #228154]

Tue, 03 April 2007 10:29

SUSAN1
Messages: 36
Registered: March 2007

Member

sorry, my bad Embarassed

Report message to a moderator

Re: import and export [message #228700 is a reply to message #228105]

Tue, 03 April 2007 15:24

michael_bialik
Messages: 621
Registered: July 2006

Senior Member

There is a BCP (Batch Copy Program) utility of SQL server. AFAIK it has the same functionality as Oracle SQL*Loader.

HTH.
Michael

Report message to a moderator

Re: import and export [message #228709 is a reply to message #228105]

Tue, 03 April 2007 19:40

SUSAN1
Messages: 36
Registered: March 2007

Member

thanks,

Report message to a moderator

Previous Topic:	Export Table to free space in Production Database
Next Topic:	Huge trace file getting created

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 16:15:42 CDT 2024