Converting excel database to mysql database

Hi:

Yesterday I installed MAMP which uses mysql 5.0.19. I tried to import my
data which was an excel file that I converted to a .csv file using excel.

I keep getting error in saying "impossible to create or read this database
when I choose and access database file.
Can this tool help me convert and excel file or is there such a tool.

Dortha Douglass



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
Dortha Douglass [ Mi, 07 Februar 2007 16:53 ] [ ID #1621567 ]

Re: Converting excel database to mysql database

Dortha,

Try WinSQL at (http://synametrics.com/winsql). It can move data from
Excel to MySQL or any other target. You need to create an ODBC DSN for
Excel, run a SELECT statement against it and export the results to MySQL





Dortha Douglass wrote:
> Hi:
>
> Yesterday I installed MAMP which uses mysql 5.0.19. I tried to import my
> data which was an excel file that I converted to a .csv file using excel.
>
> I keep getting error in saying "impossible to create or read this database
> when I choose and access database file.
> Can this tool help me convert and excel file or is there such a tool.
>
> Dortha Douglass
>
>
>
>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
Imran Abizar [ Mi, 07 Februar 2007 18:18 ] [ ID #1621568 ]
Datenbanken » gmane.comp.db.mysql.odbc » Converting excel database to mysql database

Vorheriges Thema: 5.00.11 vs 4.1 servers
Nächstes Thema: cobol odbc conection.