[JoelFord]

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,,
NO.,COLLECTED,BY,NUMBER,POINT,TYPE,COLIFORM,,,
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/addon.../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.