Sharing Microsoft SQL server 2005 database in the LAN network

Hi,
I am working on a domain network. We have the Microsoft SQL server 2005 database installed in the server.
1) I need some other users to get access to this database from their computers.
How can I do that?
2) I have some data which is stored in a text file and CSV files. I need to load that data to the new tables that I have in the current database which is MS SQL. How can I do that?
Please let me know if you have any answer for the two questions.
Thanks,