Interactive PDF with Excel Backend

We have an excel file in which the user chooses the customer and prices change for their products (a price book).  We would like to have our PDF files have their data filled in from the data in the excel file.

Is this possible and if so what software would I need?  I downloaded the trial for acrobat pro but I can't seem to find anything that will allow me to link or use a odbc link to an excel file.  Any advice?

Basically I just want the user to choose their customer number on the pdf file and then have it fill in with the appropriate data from the excel file.
Who is Participating?
K-9Connect With a Mentor Author Commented:
I was able to resolve it using corel draw
Steven HarrisPresidentCommented:
There are a few ways to do this, such as:  setting up an OLDEB database connection in Adobe LiveCycle as explained in the following Adobe Resource Article -
K-9Author Commented:
Is there any other way?  I was hoping to just throw the .pdf and excel file on our salesmen laptops where it would just pull the link locally.
You would have to do the layout in Excel already (make a seperate sheet), fill in some fields in that sheet, and then code something to print it through PDFCreator (or export PDF in Office 2010 or higher), then reset the sheet for the next print.
K-9Author Commented:
Used corel draw to fix it.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.