I think you can submit PDF forms to ColdFusion backends in any case ( http://coldfusion.sys-con.com/node/101381 ).
That'd let you feed it into Access in .014 seconds. You could do the multiselect as checkboxes if there's really no other way I think. The end. On Wed, Jul 13, 2011 at 1:13 PM, Scott Spurlock <[email protected]>wrote: > > I apologize in advance since this isn't a CF question, but I'm desperate > and hoping this is at least an Adobe question. A client of mine wants to > create a form for users to fill out electronically. He then wants to take > their responses (attached via email) and upload the data to an Access 2007 > database. He absolutely does not want this to be web-based. He ideally > wanted me to create an interactive form in PDF. I thought, "Sure, no > problem." The problems I'm running into? Importing PDF data into Access > appears to involve an extra step (converting the PDF to text or XML or > Excel) which he/the client would have to do (since he's the one getting the > returned forms). Worse is that he wants some multi-select drop-down lists > in the form and I'm not seeing a way to do this in a PDF (I've played around > with both Acrobat Pro and LiveCycle Designer). And without VBA skills I > don't have, I'm not even seeing how to do this in an Excel or Word > form. I'm getting stuck and turn to you kind sirs for your advice. How > would you do this? > > > Tha > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346217 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
