Author Topic: Excel to MySQL  (Read 685 times)

Offline Sinzygy

  • Level 28
  • **
  • Posts: 420
  • Reputation: +11/-0
    • View Profile
Excel to MySQL
« on: June 14, 2007, 12:42:46 AM »
Hi there

I'm looking for an easy way to import an excel file to MySQL

Offline Zeggy

  • Global Moderator
  • Level 35
  • *****
  • Posts: 1,187
  • Reputation: +13/-4
    • View Profile
Re: Excel to MySQL
« Reply #1 on: June 14, 2007, 03:40:54 AM »
Here's a program I found, but I haven't tried it yet:
http://www.gold-software.com/download9217.html

Or, you could save the excel file as a text or CSV file and try to import it with phpmyadmin.
Here's a section on the mySQL website that deals with exporting from excel:
http://dev.mysql.com/doc/query-browser/en/excel-mysql.html

Offline Sinzygy

  • Level 28
  • **
  • Posts: 420
  • Reputation: +11/-0
    • View Profile
Re: Excel to MySQL
« Reply #2 on: June 14, 2007, 08:02:56 AM »
thanks.

I'll go with the CVS direct-import option.

 


SimplePortal 2.3.3 © 2008-2010, SimplePortal