Wtf was that other guy talking about?
Open access, right click on your table, choose export.. from the combobox select 'ODBC Sources()'
You will get a dialog showing all the different ODBC drivers, click on the "Machine Data Source" tab, simply choose "sample-MYSQL", hit ok. After this, you will see a dialog with sections for you to place your mySQL server info into. Ie, the mySQL server (you can export remotely or locally, or over lan), Specify its hostname or Ip address. After that, fill in the username and password feilds for your database. Boom! all done.. It will export the tables and all their data into the database that you specified...
Note: where it says 'database' make sure that you put the correct database which lies on the system you are pointing to via the ip address.
Ok, well hope this helps someone --
Later
x0r
