TransferDatabase to linked tables?

[markvan]

I have a reporting system that has new records each year for the new students. I need to make a macro that will grab the comments for subjects and append them to the linked tables my mdb uses from an external mdb file.
I have gone the regular route of TransferDatabase and can easily import into my mdb tables, but I want them to be appended to the linked ones.
Any suggestions would be great? Mark Van
EZ-PC Help

http://www.ezpc.com.au

 

[AWithers]

Unless I am misunderstanding you I think you should be able to insert data into the tables in the same way as if they were really in your database. That's the whole idea of linked tables. I've certainly done that in the past

Andy