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.
http://dbtools.vila.bol.com.br/
>
>Many Thanks
>Eugene
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php