• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

load excel files

Hi ,

I need to load 4 excel files into oracle database , using sql loader , is it possible to load esxcel files into tables using sql loader , anmy help on the example script is really appreciated.

thanks in advance
0
sam_2012
Asked:
sam_2012
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
SQL Loader cannot process Excel binary files.

If you save them to a CSV or other delimited text file you should have no problem.

There are tons of sql loader control files out there.

If you want a copy/paste solution we'll need the table description, sample data and expected results.
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
Another way would be to use Oracle SQL Developer, it has an import function that supports Excel files. No sql loader though, let me know if you're interested.
0
 
sam_2012Author Commented:
Will check with the business whether they can send the csv file instead of excel . Also , what is the best columns delimiter to use like | etc , since some of the characters can appear in the data .
0
 
slightwv (䄆 Netminder) Commented:
>> since some of the characters can appear in the data .

You'll need the optional enclosing characters.

I don't think there is a 'best'.
0
 
sam_2012Author Commented:
awesome
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now