Acrobat User Community Forums

You are not logged in.     Log in to your AUC account.     Don't have an account? Sign up today

#1 2007-11-19 19:03:00

nmartin
Member
Registered: 2007-11-19
Posts: 0

linking excel spreadsheet to interactive form fields

Is it possible to auto populate fields in your document from an exsiting excel spreadsheet and also is it possible to therefore update information on that same excel spreadsheet based off of the answers generated in an interactive field? Basically can you take a spreadsheet and create an interactive from to send out via email which auto populates the fields we already "know" from the excel doc and therefore once the empty fields are filled in can you then export them back into the original excel doc to complete the spreadsheet?


My Product Information:
Acrobat Pro 8 / Windows

Offline

 

#2 2007-11-30 09:44:43

lkassuba
Moderator

Registered: 2007-06-29
Posts: 1435

Re: linking excel spreadsheet to interactive form fields

Hi nmartin,

This capabilty exists in Acrobat 8 Pro. when using the "Distribute Form" and "Compile Returned Forms" functions.
Check out Ted Padova's article on this at:
http://www.acrobatusers.com/articles/20 … /index.php

Hope this helps,
Lori


Forum Moderator and Community Manager for AcrobatUsers.com

Offline

 

#3 2008-02-01 20:00:05

scho79
Member
Registered: 2008-02-01
Posts: 1

Re: linking excel spreadsheet to interactive form fields

Hi,
To move a step further...

I've created a PDF form with some fields already populated from an XML source. I've distributed these forms and received them via email. I've compiled these forms into a single dataset where I can see all the fields on the form. But when I try to EXPORT this data to a CSV file only those fields from the XML source appear in the spreadsheet and none of the other fields that were filled out... What am I doing something wrong?

Any help would be greatly appreciated...

Offline

 

Board footer

Powered by PunBB
© Copyright 2002–2005 Rickard Andersson

AcrobatUsers.com  >>  User Groups • News • Events • Articles • Blogs • How To • Resources • Member Log in