By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,316 Members | 2,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,316 IT Pros & Developers. It's quick & easy.

Update serveral columns in a table from a newly imported table

P: n/a
I have a table(Useraccess that has several different columns of data
(userid, password, num_of_access etc) I get a different table of user
info data every couple of days. The NewTable has only the User ID and
Password. I need to be able to update the passwords in Useraccess
table with the new passwords from NewTable.

I have been trying to come up with a SQL statement that can do it all
but I have yet to be successful. Is there a better way to update my
Useraccess table? With this have to be done using ADO in VBA?

Thanks

Norris
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Create a query that includes both tables. Join the tables on UserID in the query
window. Pull down the password field from each table. Change the query to an
Update query. In the password field from the first table where it says Update
To, enter TblNewtable.Password. Run the query and the old passwords will be
updated!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"N. Graves" <ng*****@yahoo.com> wrote in message
news:55********************************@4ax.com...
I have a table(Useraccess that has several different columns of data
(userid, password, num_of_access etc) I get a different table of user
info data every couple of days. The NewTable has only the User ID and
Password. I need to be able to update the passwords in Useraccess
table with the new passwords from NewTable.

I have been trying to come up with a SQL statement that can do it all
but I have yet to be successful. Is there a better way to update my
Useraccess table? With this have to be done using ADO in VBA?

Thanks

Norris

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.