spreadsheet

[Guest]

Looking for opinions for a solution. I scan about 50 invoices a month with
OCR software that saves them as PDF. Looking to create template spreadsheet
and import data into the following way:
company name, physical address, check # and amount

Can PDF be imorted into excel or should I be looking into creating a access
dbase?

 

[CLR]

I have not done much with this, but on one project I found that if I used
the Full Acrobat Program, I could programmatically import data from a pdf
file, However, my user only had the Acrobat Reader Program, so the "import"
step had to be done by hand (SelectAll, CtrlC, CtrV) to get the data into
Excel. Then macros could take it from there and split it into columns and
manipulate it per my needs.....

hth

Vaya con Dios,
Chuck, CABGx3