It would be much better to remove all users passwords (easily done via a query), then send them all a password reset email or have them request a password reset manually (send them all a bulk email from the AdminCP).
So i've imported users from another database and they all show up in my users list like they should, when I click on them to edit their profile it wants me to create a new profile with the name I clicked on. Seems like the database doesn't know they exist but they do?
So, you only have 'details' for the xf_user table but you don't have any other data for the users - posts, avatars etc?
I'm not sure what you have is enough to 'import' a database. To be honest, if you don't have any posts or any other content from these users, you'd probably be just as well starting afresh and getting the users to register themselves.