I have a business directory which needs listings. I have an excel file with 20,000 local businesses for this directory. I am looking for someone to make an easy way to get this excel into the mysql table. The problems:
1. The mysql table is called links and has many fields more/different than the excel. I need either a excel macro to fix this or another way to better parse the excel so it matches the mysql table.
2. The description field must be unique or somewhat different. I have been doing this manually. I can give an example and looking for an automated way to get this in there. ideas welcomed.
Basically if you can either come up with an excel macro to remove and format fields to the table structure...i can then take the excel csv and do a import to mysql...