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?
Thanks..