import users
 

I have an Access db of users that I would like to use to populate my vBulletin membership. I know that I need to populate user, userfield & usertextfield tables with all pertinent information. I have a program to convert Access to MySQL and my theory is to populate all of the password fields of the user table to the same encrypted password, then have the user login and change their password. I have noticed that the salt field is also encrypted. If I fill the same encrypted password "17efa62687f5b204fa880313011f0702" in the default password field for every username and enter the correlating "]6l" for every entry in the salt field, can I assume that there will be no password errors when logging in?

Am I on the right track or is there a better way to do this? I have looked into and installed ImpEx, however I'm not importing from another message board, just an Access db.

However, you are not going to get support for ImpEx here. Please go to vBulletin.com to discuss the use and problems of ImpEx:ImpEx Import Forum Discussion

I'm not asking for ImpEx help here as I already know that it will not serve my purpose. What I am asking for is help importing data manually. I did bring this up at vbulletin.com and was told that this question needed to be addressed here.

I have successfully imported an Access file as a CSV file, manipulated the fields to match the user, userfield and usertextfield tables, then save the CSV as a SQL file and presto! I have managed to import all of the user info. If any of you need help understanding how to do this, I'll be happy to explain this seemingly difficult feet.