Im working on a project for my work and they use a program called Lab Manager which is like a case/billing system for a dental laboratory and the program is made from Access. I am wanting to design an addon to lab manager which takes information from the database and pulls it into an online account system.
So basically im asking would it be easy to pull data from an access database using mysql?
Its faster and easier to export directly from MSAccess, as a batch job, using the myODBC driver. But, if you want the process automated, I suggest creating a VB6 frontend that reads the desired records via SQL (maybe selected by date), using ADO and the Jet driver, and writes the selected records to mySQL using ADO and the myODBC driver. Slower, but with much more control.