PDA

View Full Version : PDF Help please



prefect
02-07-2011, 10:05 AM
I have been sent a new price book in Adobe PDF format for a price increase and I want to copy and paste the new prices into my Accounts program Cash Book which is Microsoft Access based. For the last 10 years I have just manually inputted everything from a hard copy to my accounting program takes about 2 days.
Problem is when I try in the pdf doc to select or high light a line the cursor line is long it takes up 12 rows. If I select copy and paste for these 12 rows it pastes goobly gook like this;

P1111R0000O11331255D5688U0016C22220034T2228 CODE CCCNDOOOIEPSUUUPCPPPLERLLLRIII INNN1P/GGGT4T" I111OB///444NS"""P BBB FSSSEPPPM FFFEEEMMM + GLLLLRLLLLPEEEEUAAAAOCCCCMHHHHD4444I0000S%%%%CP$$$ $ RNRN IEIE CG W E 114S 1146 LTLT(1268EI ....S0124XT1271C (OEPXLNNNNRDCeeeeI CLwwwwLGIESSSS TTTT %T CPO0000RHRH.... 0000LIAIAC%%%%INSEGTGT E CSOTMIOIOTYYYYMCEeeeeOssssKMKMNEDLDLY

Cato
02-07-2011, 10:38 AM
Have you tried saving the PDF file as text?
It might help.
So could this: http://www.pdftoexcelonline.com/

Or even google docs might be able to open it in a way where you could copy it more easily.

kahawai chaser
02-07-2011, 10:44 AM
Or upload to Zamzar (http://www.zamzar.com/) and convert to txt for copying.

gary67
02-07-2011, 11:44 AM
Or try the free PDF to word, it stuffs the formatting but will convert the pdf to a word document

prefect
02-07-2011, 12:28 PM
Have you tried saving the PDF file as text?
It might help.
So could this: http://www.pdftoexcelonline.com/

Or even google docs might be able to open it in a way where you could copy it more easily.
Tried that came back as excel goobly gook but thanks

prefect
02-07-2011, 12:29 PM
Or try the free PDF to word, it stuffs the formatting but will convert the pdf to a word document

Not sure that would help my accounting program is ms access based.

mzee
02-07-2011, 12:58 PM
I copy and paste from PDF's to Web editors and word processors all the time, using "Foxit Reader"
You can copy text and images on unprotected files.
Some PDF files are locked and you can not copy them without a password.
There are ways of hacking the passwords, but very time consuming.
There is a program, "Quick PDF Converter" which will convert to 'Doc', Exel, Image, or Postscript. May not work if the PDF is locked.

gary67
02-07-2011, 05:50 PM
Not sure that would help my accounting program is ms access based.

yes but once it is in a Word format copy and paste to excel from Word works

Paul.Cov
04-07-2011, 07:45 AM
There's PDFs, and then there's PDFs.

They can be created from a source file which is text based, or from images, which are useless for your purposes... but the two types can look pretty similar, but be radically different in how you handle them.

If you've been sent a PDF which has encapsulated an image, rather than a copy of the source text then you'll be totally up the creek, and would probably have to resort to OCR to try to get your source back to a text based format.