Bulk register users
 

Hi Friends*

Can anyone give me suggestion or idea to finish this job please?

I want to register 80 users for marketing campaign of my company. I've prepared all the info I need in an Excel file already. I've been trying to insert them directly to the "user" table of VB database but I cannot login with the user/password I've inserted. Am I missing something? Is there any other table or any important field I've to put the right value?

Oh and when I search for the user* it shows me a user with blank username/password/email.

Here's a sample of my SQL statement (with sample data):
Quote:
insert into user (usergroupid*username*password*salt*passworddate*j oindate*email*usertitle*ipaddress*options) values ('11'*'abc'*md5(md5('3565')+'572')*'572'*CURRENT_D ATE*1255326689*'[email protected]'*'Special Member'*'0.0.0.0'*45096279)
It's ok if I have to write a PHP script to call VB's function but I have no idea which file to include and the step to call.

Thanks*
Tony.