View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Door
 
Posts: n/a
Default Converting Data from pdf into an Excel spreasdsheet


You would firstly need to know the format of the .pdf

Format 1, if you press CTRL and A (select all) and the data you want
highlights then you can Highlight (Select) the text you require and
Copy, then Paste into Excel.
This format .pdf is produced from numbers/words in a program such as
Excel, Word etc.

Format 2, if Ctrl/A on the .pdf produces nothing than then the .pdf
might have been created from a scanned .tif or a file sent by Fax etc.

You will need to Capture (or OCR) the data shown, then copy and paste.

Hope this helps


torajudo Wrote:
I have MS Project data in a pdf (Adobe Acrobat Pro v7). As there is 6
pages
of data, is it possible to quickly extract the data (by copy/paste or
converting the file type) from the pdf form into an Excel spreadsheet?



--
Door
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=528818