Possible to Load Customer Database From Excel?

[m82492]

I built a site for a customer of mine that has an extensive existing customer database in Excel format. I would like to get her customers loaded into her new site. Is there a way to upload her customers into OSCMax similar to what Easy Polpulate will do for products?

[jpf]

Yes you can - is it easy - no.

Options:
1. Massauge the data - then put in to a CVS file then massauge it again into a SQL statement.
2. Get ODBC drivers - let excel put it into mySQL.
3. Manually enter into osCMax

There is several steps in order to do the above. Depend HOW many enties you need to do and IF you have enough information to do it.