how to convert access database to SQL Server 2000??

Question

1)I have a MS Access Database but i want to use the powerful SQL Server commands to insert, delete and update records in the database. Is it that i need to integrate the access database into SQL Server 2000 or other alternative ways in which i can use the SQL Server commands on the Access database at the same time???...........any ideas???.....THANKs 2) i know how to create a database in SQL Server 2000 but after i create, how do i create a connection string in my mobile application, which is located in localhost, to the database in SQL Server so that data access is enabled?? It is unlike MS Access where you can put the database directly in the same folder with the mobile application and a connection is established easily... TQ

Answer 1

SELECT Empid,Empname,Deptname
FROM Employee
INNER JOIN Department ON Department.Deptid = Employee.Deptid

This is the best code.

Answer 2

SELECT Empid,
            Empname,
            Deptname
FROM Employee
INNER JOIN Department ON Department.Deptid = Employee.Deptid