Merging an Excel File into an expandable table.

[yoyo112673]

Hello,

I was just wondering if there is any way to maybe insert an excel file into an expandable table which would fill AND extend the matching cells and extend the table rows per every existing field in the excel sheet.

My table currently has 3 columns with a header and footer (see below) and sometimes the data can be really large having to insert MANY new rows. What I'm trying to avoid is having two different data sources or having to do double entering.

+	Name	Id Number	Total deposit
-	John Smith	0000000000	$20
Total Deposit			$20

THANK YOU VERY MUCH!!!!

[radzmar]

Hi,

you can import a Excel Spreadsheet into a XFA form.

Here's a method, that imports the date from an attached xml (available from Office 2003).

http://blogs.adobe.com/formfeed/2010/06/display_an_xml_spreadsheet.html

[yoyo112673]

Hi, is there any way I can laod an excel file into the PDF form instead?

Thanks,

[radzmar]

Hi,

yes with a database connection, but it can become very complex.

Watch this Tech Talk on AUC to get in touch with this topic.

http://adobechats.adobe.acrobat.com/p69655795/

Also read this tutorials

http://www.pdfscripting.com/public/department48.cfm

http://blogs.adobe.com/formbuilder/2006/09/connecting_a_form_to_a_database.html

http://www.datamystic.com/datapipe/excel_odbc.html