Quote Originally Posted by twitchtoo View Post
Yes. I do this sort of thing all the time, it's quite easy.
Easy for you perhaps (because you 'do it all the time' and know more about SQL than the average shopowner) but of the methods mentioned so far this is by far the most time consuming and most risky.

As I 'hinted' in a previous reply, if exporting/import just the customer is a 'must' (which is very rare and generally indicates someone has already messed things up) then exporting/importing just the relevant tables is the way to go. No need to compare, copy and paste.

I could never recommend your method except perhaps as a last resort in the situation where the data has somehow been corrupted making a direct import impossible, and even then it is only something I'd do myself rather than suggesting it to others.

<shudder>

Cheers
RodG