Uploading Customers

Is there a utility which allowes you to upload customers from ie csv or xls files?

If not, is customer table the only that data needs to be inserted into?




Thanks in advance

I am also looking into this.

I've used a tool from EMS, called SQL Manager for SQL Server which has a host of features to easily import, although it is not a free tool.

But I also see that with SQL Server Express 2008 and the SQL Management Studio you get a handy tool to import and export data, which is free.

All you have to watch is that you fill all the required fields, I see there are a lot of NOT NULL fields that you can't ignore.

Maybe the development team will look at an built in import feature in future versions?

Actually, after doing some db snooping around, I found a whole slew of stored procedures that allow you to insert individual data.  It should be very easy to put together utility.

Import feature is on the roadmap.

Thanks,

Ben