Add names to database

[JeffPierceMagic]

I Have 200 odd names, addresses and emails from a former website. They are in excell format. Is there a way to add them to Zen Cart as existing customers?

Jeff Pierce

[schoolboy]

The difficulty with ZC database is that it splits the customer's personal data and the customer's address(es) into different tables. (This is because a customer can have more than one delivery address).

These tables cross reference each other - depending on the calls to the database.

You could probably do it using an "insert into" SQL command, first splitting your spreadsheet to conform with the table schema - and this may be easier with data that's already in a spreadsheet - but it's still a largely manual process - and you need to know your SQL !