Help me get my head around this...
I've got a few MySQL DBs that from, from time to time, I have to export the data into Access so that other people in my office can use the data (they aren't technical, so using the MySQL DB directly is out of the question). Sometimes the requests come very frequently, and can get, um, inconvenient.
So I thought about creating a script that would allow certain users to export the date from the MySQL db and import it into Access. The access file would be shared across the network, and they could access the file directly via the windows network share.
Any reason why this shouldn't work? Is it as simple as
- specify the DB to use
- connect to the MySQL db
- select all data
- connect to the Access db
- insert/update the Access db with data pulled from MySQL db
anything I'm missing here?
