473,324 Members | 2,246 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,324 software developers and data experts.

Excel User Info

Ty
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

How do I run the query to only include the 10 user names in the
Mainframe.xls?
Jul 16 '08 #1
3 1747
On Wed, 16 Jul 2008 13:10:29 -0700 (PDT), Ty <ty********@yahoo.com>
wrote:

Import or (perhaps better) link the Excel file.
Make a copy of your favorite query that you want to restrict. Open
that query in design view and add the Excel table to it. 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.

-Tom.

>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

How do I run the query to only include the 10 user names in the
Mainframe.xls?
Jul 17 '08 #2
Ty
On Jul 16, 10:58*pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Wed, 16 Jul 2008 13:10:29 -0700 (PDT), Ty <tyrone_...@yahoo.com>
wrote:

Import or (perhaps better) link the Excel file.
Make a copy of your favorite query that you want to restrict. Open
that query in design view and add the Excel table to it. 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.

-Tom.
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
How do I run the query to only include the 10 user names in the
Mainframe.xls?- Hide quoted text -

- Show quoted text -
I will have to do a "Inner Join". I will make an attempt.
Jul 17 '08 #3
Ty
On Jul 17, 1:06*pm, Ty <tyrone_...@yahoo.comwrote:
On Jul 16, 10:58*pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:


On Wed, 16 Jul 2008 13:10:29 -0700 (PDT), Ty <tyrone_...@yahoo.com>
wrote:
Import or (perhaps better) link the Excel file.
Make a copy of your favorite query that you want to restrict. Open
that query in design view and add the Excel table to it. 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.
-Tom.
>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
>How do I run the query to only include the 10 user names in the
>Mainframe.xls?- Hide quoted text -
- Show quoted text -

I will have to do a "Inner Join". *I will make an attempt.- Hide quotedtext -

- Show quoted text -
Here are my steps:

1. I imported the Excel spreadsheet.
2. In Design View I added the new table
3. connected
4. Added the Table/Field(No SQL)--I can see the "inner join"
5. Ran query
6. Seems like I locked up the database. The query is SLOW.

Jul 17 '08 #4

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

Similar topics

1
by: Dan | last post by:
Hello, I am trying to read and write to an Excel file via my Java applet. I have done so successfully on several simple Excel files that simply had data cells without many complicated equations...
1
by: C Williams | last post by:
Hi, I would like to build a small feature on a web page. I would like for a user to be able to enter the path of an Excel file into a field and then click a button that will open the file and...
1
by: ST | last post by:
Hi, I'm having problems opening up excel thru my code. It will write and saveas an excel file, but the application won't open on the user's computer, excel seems to be hidden, because it shows up...
0
by: acharyaks | last post by:
Hi life saver, I am using excel component for the development. The purpose is to connect to excel through the odbc connection string. Then through the connection extract data into a dataset and...
4
by: Jae | last post by:
I'm writing a web application that exports and imports excel files. The application gets a list of users and their info and displays it in a datagrid .The user then selects to save the file as a...
14
by: pmud | last post by:
Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the...
7
by: Alain \Mbuna\ | last post by:
Hi everybody. In my program I have some data that is calculated after some input from the user. I have written some code that opens an Excel workbook, with 5 worksheets and the calculated data...
8
by: Radu | last post by:
Hi, I have the following problem: I open a recordset based on excel/csv files, but then I need to filter (in code) in order to extract only data pertaining to a specific person. This code is...
3
by: =?Utf-8?B?TmFuY2Vl?= | last post by:
Hi All, Here is the scenario. I need a solution/suggestion how to work around this problem. My application has users with different roles. When they click on a button "Download Spreadsheet" in...
1
by: stingaway | last post by:
Have an end user who prefers to see everything in Excel, neatly grouped. I know how to export to Excel - but is there a way to export a query from Access directly into Excel with groupings...
0
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...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.