These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Creating a PDF form template to upload excel data

Forum Index > Forms: Acrobat > Creating a PDF form template to upload excel data
2011-12-20 08:48:33
PackageOne
Registered: Dec 20 2011
Posts: 2
Answered

I work for a manufacturing company and we use Excel to track a lot of our sales order information. I have created an Excel form that allows us to copy a line from our production schedule (one workbook), paste it and use reference formulas to have it fill in all relevant information into a job packet cover sheet.
 
I'm looking to go to the next level and use Adobe to create a more polished form with radial buttons or check boxes. However, I don't want to lose our copy and paste paste to fill all data feature. What I gain in presentation I'll lose in typing time.
 
Is there a way to create an Adobe template that will allow me to copy and paste table format type info in (or have it reference another file) and have it fill the data into the appropriate areas?
 
Thanks all!

My Product Information:
Acrobat Pro 10.1, Macintosh
Top
2011-12-20 08:57:25
#1
try67
Expert
Registered: Oct 30 2008
Posts: 2398
Accepted Answer
If you create the file using LiveCycle you can create a live database connection between the form and the Excel spreadsheet. If you choose an Acrobat form, you can import the data from the Excel file into your form, either directly (under same conditions) or using a script.
Otherwise, you can manually copy&paste data, but not in table form, just a single cell at a time.

- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com

Top
2011-12-20 11:35:16
#2
PackageOne
Registered: Dec 20 2011
Posts: 2
Great response. I'm not familiar with live cycle, but I'll look into it. I also found out that Excel has radio buttons and a background image capability that will allow me to do pretty much was I was after.
Top