Table Update

[zyus]

TableA
TableB

My tableA & tableB consist of two different sets of data.
Every month i want to copy all data in tableA to tableB (replace)
How to copy all data in tableA to tableB with some simple click
command/query/macro in access.

I know how to copy & paste & rename from table objects.

 

[Tom van Stiphout]

On Wed, 30 Sep 2009 23:46:01 -0700, zyus

That sounds like bad database design to me, but to answer your
question: write an Append query to copy the data. Something like:
insert into TableB select * from Table1.
Then execute it using this one-liner:
currentdb.Execute "myQuery", dbFailOnError
(of course you rename myObjectNames to yours)

-Tom.
Microsoft Access MVP