One problem I've encountered in the past creating CSV files from Excel is with fields that
exceed 256 or 258 characters. The fields end up truncated in the CSV file. A script to
directly access the data in Excel and move it to MySQL is appropriate, but can be a lot
of work if you only need to do the import one or twice.
Although this is somewhat convoluted it works for me. Start MS Access and create linked
tables to you MySQL DB. Then import the data from Excel into Access. They're integrated
fairly well so the import is basically a couple of button clicks. Then you're done.
Bob
-----Original Message-----
From: Jay Blanchard [mailto:jay.blanchard@stripped]
Sent: Friday, April 22, 2005 3:12 PM
To: Huang, Ou; mysql@stripped
Subject: RE: Write to a mysql table from Excel
[snip]
Thank you for your reply. Can you provide more details on how to write
to a MySQL table from Excel? I am a newbie to MySQL. Thanks.
[/snip]
You must be new to mailing lists too...
http://catb.org/~esr/faqs/smart-questions.html
You can save the excel as a CSV file and import that into MySQL, you can
write a program that will do it for you using any one of several
programming or scripting languages, you can use an ODBC connection.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
