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

Steve,

If the temporary table is in the database, you can create an Append =
Query to add the data to your permanent table.  The import process you =
are talking about is bringing in outside data.  If that is the case, you =
would need to use VBA to import the data to a temporary table and then =
append the data from that to your temporary table. =20

From your statement the table with the data is already in your database. =
 If that is the case you don't need to do an import.  Create a select =
query to get the data you want out of the temporary table.  Once you are =
getting exactly the data you want, change the type to Append.

James

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Steve Moghaddam
Sent: Wednesday, January 24, 2007 11:05 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: FW: Appending data in Access :VSMail mx6


James:
Both tables are in the same data base and one table which is a temporary
table (Same table name) is updated by the customer regularly and then I
appended the data in the temporary table to the second table, which is a
permanent table with all the data or the last three years.
Using import command or statement will not append the data, it creates a =
new
table.
Where as when one manually imports a file, the system will allow the =
data
from one table to be appended to the other.
=20
What Command would allow me to append data when I am importing rather =
than
creating a new table.
Thanks for all your help.


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On =
Behalf
Of James LaBorde
Sent: Tuesday, January 23, 2007 5:08 PM
To: mso@xxxxxxxxxxxxx
Subject: [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 =
=3D
regular basis with both the tables remaining the same names each time?  =
=3D
IF so you can simply write an append query to do it and then call that =
=3D
from a simple macro (openquery and reference the query) or VBA command.  =
=3D
If the input/output tables will change each time it will be a little =3D
more involved.  Can you give us some more details about what you are =3D
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
=3D20
=3D20
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
=3D20
Best regards,
=3D20

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
=3D
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 =
=3D
dropdown menu at the top.  This will allow you to unsubscribe your email =
=3D
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 =
=3D
email messages, read these instructions that explain why and how to fix =
=3D
it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
This message contains information that may be confidential and is =3D
intended only for the use of the=3D20
person/persons identified and intended as the recipient. If you are not =
=3D
the intended recipient, any=3D20
disclosure, copying, distribution or use of this information by anyone =
=3D
else is strictly prohibited.
If you have received this in error, please contact the sender =3D
immediately and delete the message=3D20
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
*************************************************************

*************************************************************
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: