Macro to copy from Calc and Paste to Base table

[ztminhas]

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.

Regards

Zafar

[Ratslinger]

Hello,
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:

Anything like executemany for embedded firebird / base?

Hello, Does using the embedded database connection allow the user to implement the executemany function that is found in 3rd party python database drivers? I am trying to implement the following. import cx_Oracle import uno def openDB(): oDoc = XSCRIPTCONTEXT.getDocument() db = oDoc.DataSource fConnection = db.getConnection("","") connection = cx_Oracle.connect(user='????',password='????',dsn='????') cursor = connection.cursor() stmt = fConnection.createStatement() stmt.execute('del…

How can I execute SQL in a Python script?

Use APSO to create and run the following macro. To see the table in Base, go to View → Refresh Tables. def createDbTable(): oDoc = XSCRIPTCONTEXT.getDocument() db = oDoc.DataSource conn = db.getConnection("","") #username & password pair stmt = conn.createStatement() strSQL = ( "CREATE TABLE Persons (" "PersonID int, LastName varchar(255), FirstName varchar(255)," "Address varchar(255), City varchar(255))") stmt.execute(strSQL) conn.close() T…

[Villeroy]

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