Home » RDBMS Server » Server Utilities » import and export
import and export [message #228105] Sat, 31 March 2007 13:37 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20899
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.
icon7.gif  Re: import and export [message #228108 is a reply to message #228105] Sat, 31 March 2007 13:46 Go to previous messageGo to next message
SUSAN1
Messages: 36
Registered: March 2007
Member
thank you
Re: import and export [message #228110 is a reply to message #228105] Sat, 31 March 2007 13:53 Go to previous messageGo to next message
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
Re: import and export [message #228123 is a reply to message #228110] Sat, 31 March 2007 23:46 Go to previous messageGo to next message
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
Re: import and export [message #228152 is a reply to message #228105] Sun, 01 April 2007 15:31 Go to previous messageGo to next message
SUSAN1
Messages: 36
Registered: March 2007
Member
thanks,
but I wonder if I want load textfiler in SQL server is the same as Oracle?

Re: import and export [message #228154 is a reply to message #228105] Sun, 01 April 2007 15:49 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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?
Re: import and export [message #228666 is a reply to message #228154] Tue, 03 April 2007 10:29 Go to previous messageGo to next message
SUSAN1
Messages: 36
Registered: March 2007
Member
sorry, my bad Embarassed
Re: import and export [message #228700 is a reply to message #228105] Tue, 03 April 2007 15:24 Go to previous messageGo to next message
michael_bialik
Messages: 611
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
Re: import and export [message #228709 is a reply to message #228105] Tue, 03 April 2007 19:40 Go to previous message
SUSAN1
Messages: 36
Registered: March 2007
Member
thanks,
Previous Topic: Export Table to free space in Production Database
Next Topic: Huge trace file getting created
Goto Forum:
  


Current Time: Wed Dec 07 12:57:45 CST 2016

Total time taken to generate the page: 0.21470 seconds