Question

How to import .doc files into Oracle 10g

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.

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?