Import From Excel
Hi,
I was wondering what would be the best way to import data into mysql database.
My sites database has different column names from what the excel will have.
Basically the excel will have most of the same data i.e. name, address etc
Is it a case of changing the column headings in the excel spreadsheet and importing into mysql via phpmyadmin?
Or is there a way Data assist can import and map fields from the data?
Many thanks