Download data from a database in chunks and append them to an CSV file

Download data from a database in chunks and append them to an CSV file

The example uses ROWIDs from SQLite. You could see if you either have a ROWIDs present or you could create one yourself. You can choose the size of the chunk/batch yourself (I use integers you might have to see if with very large numbers you might need big integers or something. Even a workaround with using strings might be possible).

This formulas can be used to split up every no of items into equal chunks and one wich contains the size of the rest.

External resources

• forum entry
• HUB: Download data from a database in chunks and append them to an CSV file