Excel to mySQL: How to Use Excel to Import/Export Tables to/from a MySQL Database

excel to mySQL

So you have an excel spreadsheet containing data you want to import into a mySQL database. You don’t want to spend time creating a database, then manually creating the fields then adding in the data. An easy way to accomplish this is to use software that will do it for you. It enables you to import excel data directly into a mySQL database or export the data to excel without knowing how mySQL works.

What it does

[Read more…]