Answer Wiki

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?

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

Processing your response...

Discuss This Question: 1 &nbspReply

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

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

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.

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

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

Share this item with your network:

To follow this tag...

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