Always being the last to input, there are lots of other
database tools out there that let you do this.
One in particular is DBTools Professional (which is what I use). You can ADO
IMPORT Excel, MS-Access, and others like FoxPro and PostgreSQL.
Another is Database Workbench, which one of the guys on this list works on.
However, if free is the way to go, then MyODBC and the format below (which I
will start using now =) ) are the ways to do it.
My 0.02...
J.R.
"cheap is good, free is better"
----------------------------------------
From: "Jerry Schwartz" <[EMAIL PROTECTED]>
Sent: Wednesday, October 18, 2006 10:17 AM
To: "'Roberto William Aranda-W Roman'" <[EMAIL PROTECTED]>, "'MySQL List'"
<mysql@lists.mysql.com>
Subject: RE: excel and Mysql?!
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]
