Talk About Network

Google





Data Bases > IBM DB2 > Newbie on SQL &...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 9094 of 9564
Post > Topic >>

Newbie on SQL & Excel

by Ty <tyrone_bak@[EMAIL PROTECTED] > Jul 16, 2008 at 01:16 PM

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




 6 Posts in Topic:
Newbie on SQL & Excel
Ty <tyrone_bak@[EMAIL   2008-07-16 13:16:09 
Re: Newbie on SQL & Excel
Philip Wright <pvwspam  2008-07-17 10:04:46 
Re: Newbie on SQL & Excel
Ty <tyrone_bak@[EMAIL   2008-07-17 11:09:24 
Re: Newbie on SQL & Excel
Philip Wright <pvwspam  2008-07-17 19:46:37 
Re: Newbie on SQL & Excel
Ty <tyrone_bak@[EMAIL   2008-07-17 17:05:33 
Re: Newbie on SQL & Excel
Philip Wright <pvwspam  2008-07-18 09:28:22 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Wed Jan 7 22:13:46 PST 2009.