473,327 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

SQL Query for Dummies

Ty
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?

1 solution given for MS Access:

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.

Thanks..

Jul 17 '08 #1
1 3839
Ty (ty********@yahoo.com) writes:
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?
Now you've mention Access and DB2, but where does MS SQL Server come
into the picture? This newsgroup is about MS SQL Server, and you should
always ask SQL questions in a forum for the product you are using, as
there are substantial differences between the SQL dialects in different
products.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 17 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: mel_dev | last post by:
All, I'm brand new to XML and have been given a deadline to deliver some new functionality part of which requires stepping through an xml doc. I have hit a wall with the way I've structured an...
3
by: Will Honea | last post by:
Two tables - table A has a column of full names (First MI Last), table B has 2 columns (First, Last) but no middle (and yes, I'd like to strangle the idiot who designed it!). Is there a syntax...
4
by: MUHAMAMD SALIM SHAHZAD | last post by:
dear respected sirs, i am in trouble as never expereince to run forms with queries based calculations here i am in insurance company they wanted this solutions: 1. tblRates (ID, Values1=...
60
by: K. G. Suarez | last post by:
Hello everyone. I am new to programming and my uncle gave me a copy of "C For Dummies 2nd Edition". I am up to chapter 9 right now. He probably saw me struggling with "The C Programming...
10
by: Roy Lawson | last post by:
Can anyone explain the difference between RowStateFilter and RowFilter properties of the DataView objects in simple terms? I am going through a Transcender practice exam and just when I think I...
2
by: Carlo Stonebanks | last post by:
I have the infamous GoF Design Patterns boo - it's been sittin gon my shelf for years. I have a huge reading list and find this book a rather dry read and am always putting it off. I have...
9
by: jardar.maatje | last post by:
I am logging scientific data. For this a normal relationship database is not idéal but I am going to try it. I have basically three tables like: datarecord: * idx - integer * time - datetime...
4
by: Eric | last post by:
I am trying to get the technician contractor(TECHCONT) of last field technician (FS_TechID or LstVldTech). It could be in Tbl_ValidDispute or Tbl_PPVResearch. In table Tbl_PPVResearch first i...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.