Saving data in datastore then in table-vba

Question

Is it possible to save all data firstly in a data structure and then save this data structure in a table in data base.

I have a process, in which I should write rows very often in a table. I want to save these rows in a data structure, and then save this datastucture only one time in table in access

Answer 1

Sure, you can create your own data structures by using

• the Type statement or
• by creating Class Modules.

The former is simpler, the latter more flexible.

Unfortunately, there is no built-in way to serialize your data structure into a table row, so you will have to write that code yourself, either by using an INSERT statement or a parameterized append query.