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

update query with multi fields

P: n/a
Hi all
If have table with the records below and these data need to be
update to another table by the name field.

name phone fax emal

ted 619
mary 855
todd to**@test.com

Is it possible to run one update query rather than create multiple
update queries or doing it manual. I will receive this type of file
everyday now.
Thank a bunch
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
co*****@yahoo.com (cong ngo) wrote in message news:<64**************************@posting.google. com>...
Hi all
If have table with the records below and these data need to be
update to another table by the name field.

name phone fax emal

ted 619
mary 855
todd to**@test.com

Is it possible to run one update query rather than create multiple
update queries or doing it manual. I will receive this type of file
everyday now.
Thank a bunch


Updated or appended? *BIG* difference! Yes, saved a canned query
with fixed criteria. Turn it into an update or append query to suit
your needs. wrap the two in a transaction if you want...
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.