Adding 2000 shipping addresses - import or manual?

Hi - I am setting up a "members-only" cart for 40 sales reps who will need between 10 and 200 address book entries each. Total 2000 addresses.

I want to set up the customer accounts ahead of time.

My alternatives:

1. Find an elegant way to import the addresses directly into the database.

2. Hire a temp for 25? hours of soul-destroying keypunch.

Can I have the group's opinion on which I should do? My gut says to key it all in through the UI - the safe and predictable route, <$500.

Thanks
Andrew

You could look at easy populate mod but I think that this is mostly atuned for product entry....I use navicat for these things as I suppose that you have these in another DB or spreadsheet???

Hi there
Easiset would be to write a SQL script to import your addresses.
You can create the script in a spreadsheet and then use phpmyadmin > SQL tab to run the script.
If you don't know what the script would look like then post the data for a record here and I will make up an INSERT line for it which you can then use to duplicate for all other records.

Thanks. I looked at the table and it seemed pretty understandable. I think SQL is the way to go. More elegant too.