Importing/Appending records into existing table in web app (1 Viewer)

[Juicejam]

I have set a datamacro to do this but as it is over 7,000 records I wish to append from one table/list to the next, it times out and cancels the macro. Any suggestions? I really do not want to have to copy and paste from one datasheet to the next as I understand there are limitations to the amount of data that can be copied each time as well.

 

[Ranman256]

The examples shown look like you are using code to import data.

You should be using an append query, using a single command:
docmd.openquery "qaAppendQry"

Which is it?

 

[Juicejam]

It's a web app so only data macros are available. The pics are data macros.