At 3:31 PM -0400 9/11/01, Eugene Mah wrote:
>I was wondering if someone could direct me to some resources where I could
>teach myself how to export data from Excel to a MySQL database.
>I have a number of spreadsheets I use for data collection, and have recently
>set up a MySQL database to stash the data in. I've managed to figure out
>how to copy/paste blocks of data into an HTML form and have PHP stick
>the data into the database. I'm looking for a way I can do it from
>now, since there are more blocks of data I need to store which are scattered
>throughout the spreadsheet. I'd like to automate the process a little more
>and go beyond the copy/paste thing.
>I've looked at MyODBC a little bit, but not enough to see how I can use it
>for this task (one of the things on my to do list).
>I expect I'll end up learning some VB for doing this.
You might want to have a look at DBTools, which can read Excel files
and dump the contents into MySQL for you.
Paul DuBois, paul@stripped