Excel 2003 Sheet

[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

I know about the Import. How do I create it to link to the other
tables in my database?

How do I run the query to only include the 10 user names in the
Mainframe.xls?

 

[Cheese_whiz]

Hi Ty,

The key is importing the data into an EXISTING table in your database. If
you do that, you can create all your queries/relationships prior to importing
that data and they will be ready when the data is imported.

You should consider using your 'pers' table. It sounds like it was designed
to hold the same kind of data and if you create a separate table for the
imported data, you will be de-normalizing your data structure. There may be
some reasons for using a separate table but you haven't really expressed any.
A separate table means two sets of queries/relationships where only one
would otherwise be needed, in addition to the denormalization issue.

CW

 

[Cheese_whiz]

Hi Ty,

My answer above is based on importing text documents. I think with excel
you can just link data using the file>get external data>link table. That
would likely be the easiest thing in most cases.

CW

 

[Ty]

Hi Ty,

My answer above is based on importing text documents.  I think with excel
you can just link data using the file>get external data>link table.  That
would likely be the easiest thing in most cases.  

CW







- Show quoted text -

The reason I have the Excel spreadsheet is because another department
gave it to me. It has only 50 names. I only want to use those 50
names.

The Pers_table is a good idea.