Expand my Community achievements bar.

Post Data to Excel

Avatar

Level 3

Hi Everyone,

I would like to have a button on a form that sends the xml data to a spreadsheet. I would also like to be able to use a button to send the data to another form.

please note...I do not want to simply generate an xml file. I already know how to do that. Instead, I want to be able to send the data right into the spreadsheet or the form.

Let's suppose that the first form, the second form, and the spreadsheet are all on my local hard drive and in the same folder. The first form is enabled and open in Acrobat. I fill it out and then click the button. Then I open the spreadsheet in Excel and see the data. Then I open the second form in Acrobat and see the data. That's the scenario. I am just trying to grasp the concepts and the mechanics for now. Later on I will apply this to a more sophisticated project.

How do I code the button?

Many thanks,

Joe

1 Reply

Avatar

Level 10

For the data exchange between two XFA-forms you should check out this example.

http://blogs.adobe.com/formfeed/2010/07/shared_data_in_packages_part_2.html

For the connection to an excel spreadsheet you will have to setup a ODBC connection to this file.

http://forms.stefcameron.com/2006/09/18/connecting-a-form-to-a-database/