I have a website form that collects data in a php / mysql database. I have a form on my Joomla website that when registered on the site you can see the form. Thus when the form is filled the data is stored.
what I want to do is push that data automatically every night to a server that will collect that data and dump it to a location where a Microsoft Access database will collect it and allow us to run a report off of the combined data from the website's php/mysql and the Microsoft Access database we have information already compiled.
In other words I want the Access to collect the data and create and update a table (apended data) for a table in the Access database....
Is this possible if so how do you recommend I do this? Using what tools the freer the better or with what I already have. On a Windows Server 2008 and Microsoft Access or SQL Server 2008 with an 5.3.1 PHP MySQL database. thank you.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code? A modern portfolio is more than just work samples, it’s also a statement of how you work.