Re: Newbie on SQL & Excel

Ty wrote:
> 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 im****t the Excel sheet and use it as the Pers table
> with only the names of the 10 employees listed in the Mainframe ex****t
> 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?
> 
> Thanks..
> 

I'm not clear on what you are trying to accomplish, but you can query
most major SQL databases (including DB2) directly from Excel using a
little VBA and ADO. I can posts links to examples if you desire.

-Philip