Talk About Network

Google





Data Bases > IBM DB2 > Re: Newbie on S...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 6 Topic 9094 of 9564
Post > Topic >>

Re: Newbie on SQL & Excel

by Ty <tyrone_bak@[EMAIL PROTECTED] > Jul 17, 2008 at 11:09 AM

On Jul 17, 9:04=A0am, Philip Wright <pvws...@[EMAIL PROTECTED]
> wrote:
> Ty wrote:
> > I'm new to SQL but not Excel
>
> > I was given a Excel spreadsheet with Employee names. =A0I 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. =A0I'm still new to
> > queries.
>
> > I can run queries using the Pers_Table with employees and other
> > tables. =A0How can I im****t the Excel sheet and use it as the Pers
tabl=
e
> > 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- Hide quoted text -
>
> - Show quoted text -

I'm trying to restrict my query to the list of names in the Excel s/
s(spreadsheet).
Here are some steps given to me.  I will attempt to do this:

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 the query to the list in the Excel file.
 




 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:03:24 PST 2009.