Project Description:
We have an MS Access database which has around 20 tables in it which I would like to explore the potential to import into a mySQL database.
The purpose of the script would be to open the Access tables and perform an INSERT IGNORE function into a mySQL database so that the data which will constantly updated on the independent Access database can be appended to the existing tables.
We have UnixODBC apache component installed and would be prepared to work with a seasoned Linux/PHP specialist to build an import function.
If this function is successful we will also want to explore a rebuild of the ASP system we are currently running into a more flexible PHP model.
