Q:

How can I upload Excel spreadsheet data into Oracle by using SQL*Loader? We now use Excel files and load data into two different tables and make a link between each row.

A:

Chuck Kelley’s Answer: Without knowing a lot more about what you are trying to do, the only way that I can think of to upload Excel data into Oracle using SQL*Loader is to save the Excel files as delimited or fixed length records and then use SQL*Loader to load them. Another way would be to import the data into Access (depending on size), create links to the Oracle Tables and then insert from Access to Oracle. Hope that I answered your question.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access