Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can excel files be directly loaded using sql loader

Status
Not open for further replies.
kdeepa

kdeepa

Programmer
Oct 27, 2002
4
IN


can any body tell me whether data in excel files can be directly loaded using sql loader.

 
Sort by date Sort by votes

Nope, you can not load directly from an excel file using sql loader.

Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War
 
Upvote 0 Downvote
Hi.
The easiest way is to save the excelsheet as csv-files and then use SQL*Loader.

Stefan
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Can deleted files/ directories (rm -r) be retrieved again?
Replies
6
Views
369
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
719
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
248
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
285
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top