You can export from Excel or Access as delimited text files, or csv. There are several choices as to the delimiter.
Here's an example from an Excel worksheet (comma delimited):
WEEK,DATE,COLLECTED,BOTTLE ,SAMPLING,SAMPLE,TOTAL,E. coli,,
1,01-May-00,Duplissie,1,121 Brookside Place,Routine,Absent,Absent,,
,01-May-00,Duplissie,2,3020 King Circle,Routine,Absent,Absent,,
,01-May-00,Duplissie,3,3162 Crescent Avenue,Routine,Absent,Absent,,
I just found, but haven't tried an automated csv dump program at http://oss.gospelcom.net/
Also, if you get MyODBC, and your server allows it, you can connect to a MySQL database with Access.
I think this was one of the links I found it at: http://www.iserver.com/support/addo...l/msaccess.html
The easiest and quickest non-automated way I've found to get csv/text (some type of delimited file) into and out of MySQL is phpMyAdmin, which is at phpwizard.net.
Whew! That's just a start.
From the day we're born, we're running out of time.