bunch of quotas to worry about. Here's what is says.Inserting rows with the Google Apps Script FusionTables service is pretty slow. There are also a
Note: You can list up to 500
However, I can't get anywhere close to that without getting the 'server error' problem. For the moment, I'm still trying to find the optimum combination, but here's how to chunk up inserts. Note I'm also using Backing off on rate limiting to deal with rate limiting of fusion requests. Assuming that array q is full of insert statements, need to tweak these to get the best batching.
You want to learn Google Apps Script?
Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Google Apps Scripts snippets >