As usual, Dan's suggestion is better than mine, especially for large amounts
of data (I usually work with perhaps 100 rows, at most). When you save a
spreadsheet as a text file, the columns will be delimited by tabs by
default.
Also, if you go with my suggestion you should probably surround any text
values with an extra pair of single quotes:
"... SET col1 = '", 'Sheet1'!A1, "', ...")
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -----Original Message-----
> From: Roberto William Aranda-W Roman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 18, 2006 8:37 AM
> To: MySQL List
> Subject: excel and Mysql?!
>
>
> hello .
>
> anybody knows how to export from excel to mysql in order to
> create or fill a database table??
>
> tanks for your help and patience
>
> cheers
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
