Automatically extract data from PDF and export to Excel or SQL

Zazism

Distinguished
Nov 28, 2011
1
0
18,510
0
This is a tall order, the policy statements for the company I work for are received in PDF format. I am looking for a way to extract specific blocks of data ( in the form of tables but they poorly structured ) from within a PDF and export them to a excel spreadsheet or sql. Are there any document management systems or tools able to do this on a large scale? Maybe a program that can scan a page and convert it to a spreadsheet?

Any help would be appreciated
 
Most of OCR software can be configured to "scan" from a picture or PDF (that's one way PDF documents are converted into editable text). It's another story what you would do with that text. You can start looking at VBA, and try to find out where your data is based on tokens within the scanned documents.
 
Thread starter Similar threads Forum Replies Date
L Apps General Discussion 3
M Apps General Discussion 5
S Apps General Discussion 3
I Apps General Discussion 2
R Apps General Discussion 1
geofelt Apps General Discussion 3
K Apps General Discussion 1
H Apps General Discussion 2
A Apps General Discussion 4
S Apps General Discussion 4
B Apps General Discussion 2
D Apps General Discussion 1
anoori9000 Apps General Discussion 1
LEOKAMBOJ Apps General Discussion 2
A Apps General Discussion 3
G Apps General Discussion 1
G Apps General Discussion 2
M Apps General Discussion 1
tarmiricmi Apps General Discussion 4
jayendrajpatel Apps General Discussion 1

ASK THE COMMUNITY