A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access - update existing table



 
 
Thread Tools Display Modes
  #1  
Old May 18th, 2010, 01:44 AM posted to microsoft.public.access.gettingstarted
accessnote
external usenet poster
 
Posts: 1
Default Access - update existing table

Hi, i have a on going database for my employees and i would like to add
another column employee ID number. On the existing table the column employee
ID is there but no number associated to the employee. I want to import from
excel. the excel file has all employees name and employee number. EE name
is the primary key and i only want to import the EE ID number only, the rest
of the column in the table leave as is. can someone help me with this?

thanks

  #2  
Old May 18th, 2010, 02:58 AM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Access - update existing table

On Tue, 18 May 2010 00:44:55 GMT, "accessnote" u60148@uwe wrote:

Hi, i have a on going database for my employees and i would like to add
another column employee ID number. On the existing table the column employee
ID is there but no number associated to the employee. I want to import from
excel. the excel file has all employees name and employee number. EE name
is the primary key and i only want to import the EE ID number only, the rest
of the column in the table leave as is. can someone help me with this?

thanks


If (and it's a big if, names aren't unique) the name is in fact unique - you
do not have any two employees who happen to have the same name - then an
Update query will do the job. Create a query joining your table to the (linked
or imported) spreadsheet by name. Change the query to an Update query, and
update the ID to

=[exceltablename].[ID]

using the actual name of the linked Excel data and fieldname.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.