ColdFusion 7/8/9 does have DDX built in that could do the job, the server can be sitting as a local intranet and is another cheaper alternative. Once you use DDX to pull the data out you can then do anything you want with the data, like stick it into a god forbid access database.
Personally I would be more inclined to use either mySql or SQL Server embeded as the RDBMS database. On Thu, Jul 14, 2011 at 6:36 AM, Bryan Stevenson < br...@electricedgesystems.com> wrote: > > It is 100% doable via LiveCycle and it will cost him 10 times what a > simple web-based solution will cost. > > I've never done it, but I know someone who will know the ugly details. > > Best of luck.... > > On Wed, 2011-07-13 at 13:13 -0700, Scott Spurlock wrote: > > > Yes, this is what I'm trying to accomplish. My client wants a PDF (or > Excel or Word) form that he can send to people, have them fill out, and > email back to him. He then wants to be able to import that data into an > Access database without having to retype anything into an Access form. > Eventually, he'll want reports to decipher the data. I was hoping to avoid > a lot of VB since I'm not too familiar with it. There will be a lot of PDF > forms, though, to justify getting to know it. I guess. After hours and > hours of research, though, I still don't even know if this is possible. > > > > Unfortunately, all of the other solutions won't work since this can't be > web-based. This is a government client and I can't just put the form > anywhere I want on the web. And it's too late at this point to try to find > a place on one of their servers since that involves a lot of red tape. Time > is not on our side. So, nothing web-based. I really wish this could all be > done on the web with a SQL Server backend, but my hands are tied. > > > > So, he wants the people to fill out a PDF form and email the form to him. > Then > > he wants to be able to scrape the form field data off and into Access DB. > > Does that sound like the issue? > > > > There probably is a better solution using Visual Basic. You might be able > > to write something in VB to use an Acrobat component to read the PDF and > fish > > out the form data and put it in the database table for each PDF. You > might even > > be able to do this in batch form. There would need to be a lot of PDF > forms to > > make it worth doing though. > > > > There is a reason that web/database work i > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:346225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm