View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default working with PDF data

Acrobat 6 (the paid version) has a function to "Select Table", then "Open
table in spreadsheet".
Acrobat Reader 6 (the free version) does not. Maybe later version do ?

A pdf table may look like a set of cells in Excel, but there is no
connection in the formats really. Unless the pdf component can put the data
into the clipboard that Excel can recognise as cells, then you will get
text. Maybe one of the other pdf components has such a feature ?

Otherwise, you need some means to recognise the end of each cell value. Then
TextToColumns or manipulating the clipboard data will be possible

NickHK

"Ram" wrote in message
...
Hello,

Can anyone clarify...

Is it possible to extract data (in table format) from PDF file to excel.
When tried to copy the table data from PDF to excel, it is pasted as text.
And if try to break it with "Text to columns" it is not breaking exactly

as
per the PDF format.

Best regards,
Ram