Importing/Appending records into existing table in web app

Juicejam

New member
Local time
Today, 15:51
Joined
Apr 15, 2015
Messages
2
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.
 

Attachments

  • datamac1.PNG
    datamac1.PNG
    13.7 KB · Views: 273
  • datamac2.PNG
    datamac2.PNG
    13 KB · Views: 255
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?
 
It's a web app so only data macros are available. The pics are data macros.
 

Users who are viewing this thread

Back
Top Bottom