This won't be a one time deal, in theory, the users will go online, click a button and their data will be uploaded from their access db to our mysql db....then in a few days, weeks, whatever, they can upload again. Hopefully each time we will grab all the new stuff. Eddie -----Original Message----- From: Adam Voigt [mailto:adam@cryptocomm.com] Sent: Monday, January 13, 2003 8:48 AM To: Edward Peloke Cc: php-db@lists.php.net Subject: Re: data move Umm, if it's a one time deal, why not just have access output a CSV (comma seperated version, or something like that) and use PHP or phpMyAdmin if it will do it, to do your insert's? That way you don't have to have PHP interface with Access, just the MySQL part which is real easy. On Mon, 2003-01-13 at 09:12, Edward Peloke wrote: Ok, I know I have asked this question several times but it is time for me to start coding so I am looking for some goog tutorials somewhere. I need to use php to transfer data from an access file to mysql db. I assume I will just use an odbc connection but I am unsure as to where to start. If anyone knows of any good tutorials or samples, please point me in the right direction. Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Adam Voigt (adam@cryptocomm.com) The Cryptocomm Group My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc
