importing users into wordpress from csv

Hi,

I've got nearly 500 users to import into a wordpress site. I want to set their ID as the login name and the password, and I want to assign them into an specific user role.

Do you know which is the best way? can I do it directly importing them into a table of the database?

Any help will be appreciated.