Devam Ediyor

474294 Get Excel data into mySQl script

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...

Beceriler: Her şey Kabul, Veri Girişi, Excel, MySQL, PHP, Kabuk Betiği

Daha fazlasını gör: table data structure, local businesses ideas, import csv into mysql php script, data structure problems, data structure example, data entry macro, automated data entry, doing data entry for a business, need to get excel, import listings, import excel, fix excel macro, do get give, c# import excel, c import excel, csv file business directory, php data table, php import excel file mysql, macro script file, excel file mysql, parse table, mysql structure, php excel csv, import csv data mysql, excel macro csv

İşveren Hakkında:
( 51 değerlendirme ) mt juliet, United States

Proje NO: #2220198