Macro to copy from Calc and Paste to Base table

Good Afternoon,

Normally when i receive data from a sheet, and if that sheet is from a Calc workbook, i can copy and paste this to a base table. I would like to automate this process either in Basic or Python. Any help will be appreciated.



Your question is very general in nature. This appears using SQL in the macro to update the table would work. Seems you already have this code:

Base, Calc, Python: INSERT, UPDATE, DELETE from spreadsheet

1 Like