appending lnked table

[gr8whitewaldron]

hello, i have a master table, and table that is to be linked and an append query that is run that combines the two tables into the master. I was wondering if theres is a command (sql or basic) to link the other table and choose the table to use. It will have to be done a few times, which is why it will be most convinient to run a code that will link, run the query, and delete the linked table.

Thanks in advance.

 

[gavinjb]

Hi, I take it from your message that you want to
1. run an append query
2. delete a linked table from the database

One way to do this is to run the following code in VB

currentdb.execute "querynamehere"
currentdb.execute "DROP TABLE tabletodrophere"

Not usre which version of access you are working, and haven't needed to use this while developing access 2k Databases yet, if you have any problems with Access 2k+ you might need to reference the DAO Library.

Gavin,

 

[gr8whitewaldron]

That is the command I am looking for, thanks.