PDF>EDI HELP!!!

Trying to convert pdf documents from Adobe Reader to a file format like txt so that EDI software can convert the information into a customer order. The following are our attempts and the resulting challenges. We cannot download software like Foxit. Need to be able to accomplish this with Adobe Reader and programs already on the office computer.

• Copy everything in the pdf and paste into Excel -> this creates a data dump with orphaned data and inconsistent table formatting; use of formulas to capture the relevant data is thwarted by these issues because we need the system to accurately and reliably reflect the customer's order which will consist of a part number, quantity, unit of measure and price. Possibly need to capture shipping addresses as well.
• Copy everything in the pdf and paste into wordpad or notepad -> same sort of issues that result in unreliable data transfer
• Copy everything in the pdf and paste into Word, then copy everything in Word and paste into Excel -> this produces a better looking result, but still having issues with consistency of data for the formulas to capture it due to differences in the length of part descriptions which will push data into the next cell. Shorter part descriptions will result in fewer rows housing the data, while longer descriptions will result in the data being spread across more rows.

Possible Solution:

> Use of a macro instead of formulas to capture the relevant data?