- get data from ms access db
- edit / format it (ie. strip out commas and/or place quotes around each field)
- export to csv
- send to web server
- cron job which periodically checks for new csv file and acts accordingly, places data in mysql db
I know this isn't specifically a php question, but the only idea I've come up with so far is some VB code within the Acess db, that will do all of this including sending to the web server. As the client literally doesn't want to do anything more then press a button in access / run a batch file or equivalent, it is proving quite a headache for me (esp with my limited VB knowledge
Anyway I guess what I'm looking for is for those of you with some Access knowledge, whether you think my method would be the best way, or is there some alternative way that I've looked over? Can an access db be uploaded and worked with by php functions before placing in mysql? Although this wouldn't be ideal given the size of the Access DB and the constant changes ie. uploading. Thanks for any suggestions.