Imported Tables

R

R Tanner

Hi,

I have imported about two years worth of data into Access and I have
certain fields that I would like to convert to an ID number. For
example. I have servers that I would like to replace with the server
ID. How would I do this?
 
K

KARL DEWEY

Back up your database ------

Create a cross-reference table with server name and ID fields. Add the new
ID field to your orignal table. Create a select query using your orignal
table, run, note the number of records. Join the two tables in the select
query on the server name fields, run, note the number of records.

If different from table alone the make it a left join from orignal table to
cross-reference table. Use criteria of Is Null on the server field of the
cross-reference table and click the sigma icon (looks like sideways M) to
make it a totals query. Run to see what was left out of the cross-reference
table.

If there is no difference then change to update query and edit the ID field
of orignal table to [cross-reference].[ID] and run.
 
R

R Tanner

That is a little above me...Do you have any good books you could
recommend to really delve into Access and take advantage of doing
different things? I am trying to do some things with relational
tables and one is linked to an excel sheet, updating from it...Any
suggestions? Thanks.
 
Top