Import PDF Files to Oracle I/PM with Excel sheet containing Index fields

Hi Experts,

I have a questions about Importing Data into Oracle I/PM.  I have several PDF files (check Images) and a Excel sheet (Index fields I want to import).  Is there a utility or way of importing this data while checking the excel file index files.  

Thank for all your help.  

-Jeff
storktechAsked:
Who is Participating?
 
MikeOM_DBAConnect With a Mentor Commented:
1) Import your pdf files into a table in your Oracle database with type either as "BFILE" or BLOB.
2) Save your Excel index fields as "csv" file
3) Attach that csv file to database as external table
4) Code an sql query to update the pdf table with the index info.
5) Go celebrate your success.
:p
0
 
storktechAuthor Commented:
Haha I will accept this as the solutions. Stream lined and it worked out. I have not run into a problem yet.  

Thanks Expert!
0
All Courses

From novice to tech pro — start learning today.