0

I used SQL loader it works fine if i have single sheet but i encountered few obstacles while loading multiple sheets in to a pre-existing table. could any one suggest me the best way.

Improve this question
3
  • possible duplicate of Load Excel data sheet to Oracle database Commented Sep 10, 2014 at 7:34
  • tl;dr you can't. You either need to parse the xls(x) in a different language and load that row by row of convert it. Commented Sep 10, 2014 at 7:35
  • finally i have done it by Apache POI.. Commented Sep 26, 2014 at 4:54
Related questions
4
Create an Excel Spreadsheet from a Oracle Database
0
Importing records from excel to oracle
0
Importing or exporting data to & from Excel to Oracle database
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.