Got it. Two options:
-
See this example. It may take a while (one row at a time), but it should get the job done. Modify the code slightly with a For loop that can be interrupted with no ill effect:
Importing existing data into Data Table - #10 by chrisfor [rowid for rowid if not rowid in current_data_table_ids ]:
–anvil.server.call(“import_row”, rowid) -
since you have an external database already, you could just connect to it. What format is it in?