pdf to excel

[angrymob]

does anyone have any knowledge how to change pdf data to excel trying to find a way to put horse and dog data into a database thanks

<font size=-1>[ This Message was edited by: angrymob on 2002-07-29 00:53 ]</font>

[Equine Investor]

If the data is in table form in pdf then here's what to do...

Firstly you need more than the Acrobat Reader, you need the full Adobe 5 program.

In Adobe Acrobat 5.0, open the PDF document. Make sure you are working in Adobe Acrobat 5.0, as opposed to the Adobe Acrobat Reader.

NOTE: PDF documents on the Web open in the Reader, even if you have Adobe Acrobat 5.0 installed on your workstation. If you would like to export a table from a document on the Web, you must first save the PDF document within your browser (Select File -> Save As... etc.) and then open it in Adobe Acrobat 5.0.

From the main toolbar, select the Table/Formatted Text Select Tool (or click Shift+V). This tool's icon, , will appear in the main toolbar once it has been selected from the drop down menu.

NOTE: If you prefer to export a column of data as opposed to an entire table, you can use the Column Select Tool as opposed to the Table Select Tool and continue with the instructions.

Select the table that you would like to export by clicking and dragging a box around the table.
Right click within the box. A menu window will appear.

Make sure that the Table option is checked.
Select Save As…from this window (select Copy if you are using the Column Select Tool).

Select a file in which to save your table, and type a name for the file containing your table. In the Save As Type window select ANSI Text (*.txt) and click on Save.

Now minimize Adobe Acrobat 5.0 and open Excel.
In Excel, select File -> Open….
In the Open window, make sure under Files of Type: Text Files is selected. This way you will be able to see your .txt document.
Select your table.
Select Open.

The Text Import Wizard window will appear.
Observe the Preview of File window. View the entire table by scrolling to the bottom of the file.

Hope this is not too confusing and remember you need the full program not just the reader.

Cheers.

[angrymob]

thanks equine for prompt reply will have to save up and buy acrobat most sites seem to use pdf now thanks again