I'm new to SQL but not Excel

I was given a Excel spreadsheet with Employee names. I have a large
database with a Personal Table with Employee names and a whole list
of
other tables that I'm used to running queries. I'm still new to
queries.

I can run queries using the Pers_Table with employees and other
tables. How can I import the Excel sheet and use it as the Pers
table
with only the names of the 10 employees listed in the Mainframe
export
of Employees.

My files:
Mainframe.xls for 10 mainframe users.

My tables:
Auth_id for user id's
CostCtr for Cost center codes

I'm attempting to do the above in MS Access.

Is there a way to do the above via SQuirreL SQL(an open-source Java
SQL Client program) on a DB2 database?

1 solution given for MS Access:

Drag a common field (perhaps EmployeeID) from the Excel table to the
Pers_Table. This operation is called "creating an inner join".
Run the query. It will now restrict.

Thanks..

Ty (tyrone_bak@yahoo.com) writes:
> I was given a Excel spreadsheet with Employee names. I have a large
> database with a Personal Table with Employee names and a whole list of
> other tables that I'm used to running queries. I'm still new to
> queries.
>
> I can run queries using the Pers_Table with employees and other tables.
> How can I import the Excel sheet and use it as the Pers table with only
> the names of the 10 employees listed in the Mainframe export of
> Employees.
>
> My files:
> Mainframe.xls for 10 mainframe users.
>
> My tables:
> Auth_id for user id's
> CostCtr for Cost center codes
>
> I'm attempting to do the above in MS Access.
>
> Is there a way to do the above via SQuirreL SQL(an open-source Java
> SQL Client program) on a DB2 database?

Now you've mention Access and DB2, but where does MS SQL Server come
into the picture? This newsgroup is about MS SQL Server, and you should
always ask SQL questions in a forum for the product you are using, as
there are substantial differences between the SQL dialects in different
products.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx