Prev: XL2007 French Numeric Formats
Next: Excel 2003 & Sharepoint
From: Beth on 30 Apr 2010 13:06
I have a data table in a PDF document that I would really, really like to
import into Excel so I can manipulate the data. The PDF settings cannot be
changed in any way - it's how the program that creates the PDF file is
written, and I don't have/can't get rewrite privileges. At work I have
Excel 2003, at home I have Excel 2007. I have the document saved on my
computer as a PDF, and I also have a hard copy.

Is this possible, and if so, how?

Thanks!
From: Ron de Bruin on 30 Apr 2010 14:23
Hi Beth

I use AbleExtract for this
http://www.investintech.com/prod_options.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"Beth" <Beth(a)discussions.microsoft.com> wrote in message news:4815D23C-53B2-4D1B-9C55-F0A6698BCA76(a)microsoft.com...
> I have a data table in a PDF document that I would really, really like to
> import into Excel so I can manipulate the data. The PDF settings cannot be
> changed in any way - it's how the program that creates the PDF file is
> written, and I don't have/can't get rewrite privileges. At work I have
> Excel 2003, at home I have Excel 2007. I have the document saved on my
> computer as a PDF, and I also have a hard copy.
>
> Is this possible, and if so, how?
>
> Thanks!
From: Sean Timmons on 30 Apr 2010 14:24
..PDF's don't typically come out so godo in Excel.

File > Export and try out the formats to see what comes out best. But,
you'll probably have to adjust data either way...

"Beth" wrote:

> I have a data table in a PDF document that I would really, really like to
> import into Excel so I can manipulate the data. The PDF settings cannot be
> changed in any way - it's how the program that creates the PDF file is
> written, and I don't have/can't get rewrite privileges. At work I have
> Excel 2003, at home I have Excel 2007. I have the document saved on my
> computer as a PDF, and I also have a hard copy.
>
> Is this possible, and if so, how?
>
> Thanks!
From: Jeff on 30 Apr 2010 15:26
As goofy as it sounds, have you tried to copy and paste? I have data from a
pdf source I bring into Excel every week. There are some slight quirks, but
it works for me with a little manipulation. Helpful hint is use the Alt key
and mouse on the pdf to select what you want to copy (ctrl+c) and do not
paste special into excel. Hope if maybe works.

Jeff

"Beth" wrote:

> I have a data table in a PDF document that I would really, really like to
> import into Excel so I can manipulate the data. The PDF settings cannot be
> changed in any way - it's how the program that creates the PDF file is
> written, and I don't have/can't get rewrite privileges. At work I have
> Excel 2003, at home I have Excel 2007. I have the document saved on my
> computer as a PDF, and I also have a hard copy.
>
> Is this possible, and if so, how?
>
> Thanks!
From: Billns on 1 May 2010 19:06
On 4/30/2010 10:06 AM, Beth wrote:
> I have a data table in a PDF document that I would really, really like to
> import into Excel so I can manipulate the data. The PDF settings cannot be
> changed in any way - it's how the program that creates the PDF file is
> written, and I don't have/can't get rewrite privileges. At work I have
> Excel 2003, at home I have Excel 2007. I have the document saved on my
> computer as a PDF, and I also have a hard copy.
>
> Is this possible, and if so, how?
>
> Thanks!

Adobe Acrobat or a substitute program should work as long as the data
table is really a table and not just an image.

Consider scanning your hard copy, then using OCR to bring the data into
either Word or Excel. I've scanned/OCR'd some old typewritten articles
from the early 80's into Word with very few errors.

MS Office Pro Editions include a pretty good built-in scan to OCR
application.

Bill
 | 
Pages: 1
Prev: XL2007 French Numeric Formats
Next: Excel 2003 & Sharepoint