Re: How to import data from unique Excel Spreadsheets to MySql Data Table?

[Javier Treviño]

Hi Steven,
Thanks for writing in our forums!

If by "mapping" you mean taking data from a manufacturers products table to a products listing table and you want to do this using MySQL for Excel you can easily do it using the Append Data functionality.

First you would need to select the table where the source data resides (i.e. your manufacturers products table), import the data to an Excel worksheet, then massage the data to suit your needs (change values, delete rows you do not want to copy to your target table), then select ONLY the data you want to copy to your target table (i.e. your products listing table) and select the target table in the tables list then click Append Data, you will see in the Append Data dialog there is a way to map source columns to target columns regardless of their names, you can drag&drop columns from the source table to the target table.

Hope this helps.

Regards.

====================================
Javier Treviño
MySQL on Windows Team