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]