[mso] Re: FW: Appending data in Access :VSMail mx1

Steve,

Are you looking to take data from one table and add it to another on a =
regular basis with both the tables remaining the same names each time?  =
IF so you can simply write an append query to do it and then call that =
from a simple macro (openquery and reference the query) or VBA command.  =
If the input/output tables will change each time it will be a little =
more involved.  Can you give us some more details about what you are =
trying to accomplish and we can better help you.

Thank You,
James

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Steve Moghaddam
Sent: Sunday, January 21, 2007 5:04 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] FW: Appending data in Access :VSMail mx1


How can I append data from one table to another using Macro, or VBA.
Thanks
=20
=20
ZurvahnLLC
Your Supply Chain Management Expert
*Office Mexico: (480) 626-4063
*Office Tucson: (520) 743-2939
*Cell: (954) 778-9238
*  <mailto:m.steve@xxxxxxxxxxx> m.steve@xxxxxxxxxxx
=20
Best regards,
=20

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the =
dropdown menu at the top.  This will allow you to unsubscribe your email =
address or change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your =
email messages, read these instructions that explain why and how to fix =
it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
This message contains information that may be confidential and is =
intended only for the use of the=20
person/persons identified and intended as the recipient. If you are not =
the intended recipient, any=20
disclosure, copying, distribution or use of this information by anyone =
else is strictly prohibited.
If you have received this in error, please contact the sender =
immediately and delete the message=20
from your computer.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: