Stephen Johnson wrote:
> I have a client that uses an Access dB in house and wants that database to
> automatically update a MySQL database that I am creating for their website.
> Is this possible and if so where can I find some reading material on how to
> accomplish it?
>
> Thanks for the information
>
Use MyODBC of course.
If they are not updating the MySQL table directly you will need to generate a
macro to select into the table. I do not have a specific example but
something like.
DELETE FROM table;
INSERT INTO table (col1, col2, ...) SELECT a_col1, a_col2, ... FROM
access_table WHERE...
--Bill
---------------------------------------------------------------------
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