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

Reply via email to