b]Is Append Query the only way to append data to a table???

[jane30]

Hi, there!

I want to append TABLE1 in current DB1 to TABLE ALL in DB2. TABLE1 contains only one month of data. TABLE ALL contains year-to-date data. In this case, do I have to use append query to create a year-to-date table in DB1 first, then export it to DB2? Or there is some other way?

Many many thanks in advance

 

[GymRatPA]

you can also code the .newadd
but for quickness the append qry from tbl1 to tbl2 is easiest.

 

[JaneC]

Hi,

In DB1 you can create a link to TABLE ALL in db2. (File, Get External Data,Link tables).

You can then reference TABLE ALL as you would any other table in your database so you can then set up an append query within db1 to append records in TABLE1 to TABLE ALL.

HTH


Jane

 

[MichaelRed]

But ... you may also use an Update query.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over