I have made an Access 2000 application for a real-estate company. My client will be exportign his Access data in a MySql database which will produce dynamic HTML pages (with some scripting) in an ISP server. So, his data will be published at the Internet, this way. My client will need to just click a button (while he is in Internet) and the data be exported from his Access tables to the MySql server (he could also export the data to a local mysql database in his computer and then upload it to the ISP server, maybe a better way). I am trying to find out how to make this for him as simple as possible. I have downloaded DBTools 1.08, MyAccess (an add-in for Access 2000) and MySqlFront. I have tried DBTools and it works ok exporting Access table data to an empty MySql database (the 'MyAccess' add-in gets stuck, and i haven't tried MySqlFront yet). Initially, I set the Import wizard (of DBTools) to export data and structure. It exported all the tables, except some (maybe because of data type mapping inconsistencies, specifically with null date values in Access). I created those tables by hand and then I was able to export all the data to the empty mysql database that i had just created. I need to find an automated way for my client to export his data (probably with DBTools) with a simple click (either from inside Access or from an outside program). Can he just append only the new data to the mysql database, or he will have to re-export all the data (including the new ones), something i dont mind, anyway? I want to avoid to recreate all the tables each time. I would prefer to have an initial empty mysql database and each time export all the Access data (including the new ones) to a copy of this empty database (for the reason i referred before). So this updated mysql database would then be uploaded to the ISP server. Is there any way to do this automated thing? I was thinking about using a sort of automated task program but iam worried that this method will give me some trouble. I will appreciate any help. Vasilis --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
