At 03:12 PM 4/22/05, Jay Blanchard wrote:
[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.
Don't be so hasty to criticise. I took the original question to mean "While I have an existing spreadsheet open in EXCEL, can I cause a selected row in a MySQL table to be updated?". This is quite a different question than "How can I convert one sheet from an EXCEL file into a new MySQL table?". The later can easily be done several ways as you suggest, the former cannot. Can the former be done with ODBC? I didn't find any answers on google.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
