Mysql For Excel and options to import Excel table in Mysql

Asked

Viewed 441 times

0

I am trying to import a database that is in Excel format to Mysql.

I was trying with Mysql For Excel, launched same company.

As you can see in the image below it is already installed:

In my Excel nothing appears,in the example that has on the official website was to appear where is the black box:

Do I need to make any extra settings? There is another alternative besides this?

mysql excel
  • 1

    File > Options > Add-ins > COM Add-ins, check that the Mysql For Excel option is in the list and that it is marked @Rodolfo Oliveira

  • 1

    Particularly I do not like this tool, I prefer to import via command LOAD DATA INFILE, or when I need to create the table when there are several columns use the site http://www.convertcsv.com/csv-to-sql.htm

  • Any special reason you don’t like Mysql for Excel?

No answers

Browser other questions tagged mysql excel

You are not signed in. Login or sign up in order to post.