asked on

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.

Steven Harris

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 - http://help.adobe.com/en_US/livecycle/9.0/designerHelp/index.htm?content=000553.html

K-9

ASKER

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.

Kimputer

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.

ASKER CERTIFIED SOLUTION

K-9

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

K-9

ASKER

Used corel draw to fix it.