Macro to copy from calc and paste to base?


I would like to know if there is a way to copy data from calc sheets to a pre-setup data base. The database exists, it is empty of data. I am aware of manual copy and paste method. I would like to have this done via macro. Thank you very much for your help.

Calc2HSQLDB.ods (27.5 KB)
Oops, the macro is not embedded: (27.0 KB)

1 Like

Thank you for this. I will check it later today.