List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 11 2001 7:51pm
Subject:Re: Sending data from Excel to MySQL
View as plain text  
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 
>within Excel
>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.

>Many Thanks

Paul DuBois, paul@stripped
Sending data from Excel to MySQLEugene Mah11 Sep
  • Re: Sending data from Excel to MySQLPaul DuBois11 Sep