How to import .doc files into Oracle 10g

Tags:
Oracle 10g
I am using Oracle 10g, and i have around 500 tables sitting in .doc file. How can i import those tables into Oracle 10g. Please help me out with this issue.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You say that you have tables in a .doc file, but don’t really say what is in the doc file. Are the table descriptions in the .doc file? Are the descriptions and data in the doc file? is just lots of data in the doc file? It’s difficult to give a good answer without detailed understanding of what is in the .doc file.

If you have separate table descriptions with their data in the doc file, I would recommend saving the doc file as text, create the tables using the table descriptions/definitions and then using SQL*Loader to get the data into the database. It may be tedious, but it works. If you just want to load the file as a single unit/object into the database, then that would be possible too.

S-Factor: Since you have it in .doc and you are running 10g, it’s a breeze. All you need do is copy and paste all the table into excel, save as .csv , then create an application from your 10g by importing from the .csv .
I hope it’s clear enough?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Brijesh
    Hi,

    Save the doc file as text, create the tables using the table descriptions/definitions and then using SQL*Loader to get the data into the database check the resource  Using Oracle SQL Developer to Setup SQL*Loader Runs which is similar create by following this.
    Hope this helps.
    9,680 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following