Hi everyone!,
I been using chronoforms quiet awhile and on my webpage and we do have a basic registration form. My boss ask's me if there's any way possible to convert that data received of the chronoform into an access table database? Not a complicated conversion, something very simple. Any help? Thanks!
Jorge
Hi jorge,
You an export to CSV (or Excel) and re-import to Access; or I believe that you can link Access to MySQL using OBDC but I've never tried.
Bob
Hi Jorje & Bob,
You can indeed access a Microsoft Access server using ODBC and an appropriate driver from PHP. This however takes you away from the comfort of Joomla and/or ChronoForms. For simple Inserts, the SQL-code is pretty much identical to MySQL (apart from some extended functions).
I recall there's a native PHP-driver for MSQL in fairly recent releases of PHP as well, though whether your hosting company choose to enable this component or not is a different matter.
I'll see if I can't dig up some code in the following days.. Feel fre to bump/remind me in a day or two, as I tend to get easily distracted every now and then (especially when it's the end of the hunting season..)
/Fredrik
Thanks for your soon response!
One last thing,
The form i made redirect the results to a hotmail account. My question is: How exactly is the most effective way to receive the results submitted from the people to export em in a .csv or excel table?
Thanks again for all your help,
Jorge
Hi thechaka,
If you have a DB Connection in your form you can click the link in the Forms Manager to get to a data viewer with Export to CSV & Export to Excel icons.
Bob