Connecting Tech Pros Worldwide Forums | Help | Site Map

How to Read Data from ONLINE PDFs and enter into an Excel database

Newbie
 
Join Date: Mar 2009
Posts: 2
#1: Mar 15 '09
Hellow Helpers:

I am doing data entry job manually and data is huge. Now I was told to write/get some sort of program/script which can do this job quickly, otherwise I will loose job. I am good computer user but far away from programming, however I can make minor/little changes into script/program e.g. if it reads one records, I can update record name to read or ask to read next record. This is all my knowledge/skills about programming. Here is my problem:

Need any kind of simple script (any language does not matter) which "Extract/Read Data from ONLINE PDFs and enter into an Excel database.
PDF doc data could be in table form or text.
It may need to skip/ignore some data (useless data)
Some time PDF files are downloaded on PC, then OPEN file from specified location, read data, enter into excel database and OPEN next file untill all files are read.

To run this scrip, if need to install any program, please let me know which one and where to find (any free version would be appreciated).

Please also mention, how & where to run this script e.g. on command line or how?

I am using following system:

Using Windows XP
Internet Explorer 7.0.5730.11
Acrobat Reader 5.0.0
MS Office 2003

Anyone can help, please do not assume I will understand hints, need full script in stated scenario.

Thanks all reading and helping in advance. RK

debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,511
#2: Mar 17 '09

re: How to Read Data from ONLINE PDFs and enter into an Excel database


i don't think there is any tool which will satisfy your exact purpose.

You need to write your own script as your requirement is not so simple
Newbie
 
Join Date: Mar 2009
Posts: 2
#3: Mar 17 '09

re: How to Read Data from ONLINE PDFs and enter into an Excel database


My problem is simple now, is there any tool or script which "Extract/Read Data from ONLINE PDFs (PDF is embedded in web page) and enter into an Excel OR

Copy entire PDF data (PDF embedded in web page) with single click or automatically.

I am not a programmer. Any help would be appreciated.

Thanks,
Riak
Reply