PDF file import

M

mkingsley

I have a PDF file from a vendor, that basically resembles a table.
have tried to import it into Excel so I can make an order form out o
it, that calculates price and taxes. I have tried fixed width, an
delimited conversions, but the resulting worksheet looks like garbage


Thanx

Zala
 
H

hgrove

mkingsley wrote...
I have a PDF file from a vendor, that basically resembles a table.
I have tried to import it into Excel so I can make an order form
out of it, that calculates price and taxes. I have tried fixed
width, and delimited conversions, but the resulting worksheet
looks like garbage.
Click to expand...

The commandline utility available from Simtel suing the following url,

http://www.simtel.net/pub/pd/51612.html

has been very useful for me. It converts PDF files to space-formatte
palin text. Excel can handle plain text, but it can't really handle PD
files even if you try to open them as text files
 
F

Frank Kabel

Hi
as a PDF file was originally meant to be the LAST step in a document
creation process all conversion back to a changeable format could
require manual effort.

You may search Google for 'PDF converter' and try them.
 
M

Myrna Larson

In addition to the other suggestions, from with Acrobat Reader, you can click
the Select Text (or Select Table) button, select the information, CTRL+C to
copy it, then switch to Excel and paste it into the worksheet. If this
document is a multipage catalog, this solution may not be too appetizing.

If you have Word, you could try the Recover Text from Any File feature. Or if
you have OCR software, print the PDF file, scan and OCR it.
 
Top