Thanks for the useful link cyberspeed. I test the script and it works fine. You can also try to download this Mambo component that import users (as .csv) you can then synchronize with your Community Builder afterwards.

mamboforge.net/frs/?group_id=2039&release_id=5691

Again, Do not forget to backup your database.

Wow, Great stuff. Thanks for the quick and pertinent response.

Damn, now I am getting no administrators set up after installing CB. I figured this problem out a long time ago but any help would be appreciated.

I suggest you better read the documentation for proper installation and all about CB.

I installed it ok. After alot of research, I found the problem. The fix is in the following thread:

forum.mamboserver.com/showthread.php?t=44272&highlight=administrators+set

About 4 posts down.

Found the Joomla! User Import ComponEnt (JUICE)
developer.joomla.org/sf/projects/juice
JUICE is an component for Joomla! that allows a site administrator to import users from a CSV text file

This will import the username,password,fullname and email only.

If i want to insert data into other fields created with CB, which tables should i mess around with?

Many thanks in advance.

Jojo