« Return to Thread: Excel spreadsheet

Excel spreadsheet

by Tyrone Baseck :: Rate this Message:

Reply to Author | View in Thread

Some parts of this message have been removed. Learn more about Nabble's security policy.

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?
 
 


Time for vacation? WIN what you need. Enter Now!
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

 « Return to Thread: Excel spreadsheet

LightInTheBox - Buy quality products at wholesale price!