I have a etail website that has many etailers to be on there. i will be helping some of them with their data sources and data entry.
The manufacturer use many difft formats and standards of supply data and difft field names to their data titles.
how to make it easier to get the data into the Master Worksheet. Map it to the right product fields titles.
like Product Specs vs Product Spcs, vs Prod Specs or even less obviouis.

It will not work right but able to compare the data to the table entries would be good.

the data source, Online sites, DVDs/CDs, emails zipped folders, downloaded folders files, csv, txt, docs, images in folders or files, XML, html,
ODF? and more

and each store I support their data entries would havre a separat worksheet that would pull data from the main worksheet which connect by a DSN MYSQL connector I created that links to the MySQL Dbase Products_Tbl withabout 86 field titles in it!
I would only use about 18 to 25 of them normally for my data entry. Some are created by an online form or the buyers click a rating box or simliar. Als the Manufactures could post their products data too as a wholesaler in part of that table too.
I was told a PHP file could be made that could be put on a site that would help get the products of the stores into the dbased by
a inteligent file smart tool / app to change the difft source types and data types to fit into the table. also a good idea but how to that also.

Sincerely
Scron