🚀 go-pugleaf

Yes, you can update tables from a database. You can either re-generate the table from scratch dynamically, or (if there is always a fixed number of rows) just set the text content of existing cells in a table.

For example a VB script could run an Oracle stored procedure or SQL query over ODBC, and iterate through the resulting recordset, adding (or updating the content of) rows to a table as it goes.

You can dynamically format the rows and cells of a table, and the format/styles of text within that table. Here's a brief extract from such a script that should give some idea:
...
' get field from database
sSubHeader = rs.Fields("SubHeader")
' i increments for each record/row
oTable.Rows.Item(i).InnerColumnStrokeType = idNoStrokeType
oTable.Rows.Item(i).KeepWithNextRow = True
oTable.Rows.Item(i).Merge
' set content of cell
oTable.Rows.Item(i).Cells.Item(1).TextContents = sSubHeader
oTable.Rows.Item(i).Cells.Item(1).Texts.Item(1).AppliedFont = "Helvetica"
oTable.Rows.Item(i).Cells.Item(1).Texts.Item(1).FontStyle = "Medium"
oTable.Rows.Item(i).Cells.Item(1).Texts.Item(1).PointSize = 7
oTable.Rows.Item(i).Cells.Item(1).Texts.Item(1).Leading = 7
oTable.Rows.Item(i).Cells.Item(1).Texts.Item(1).HorizontalScale = 100
oTable.Rows.Item(i).Cells.Item(1).Texts.Item(1).Tracking = 0
oTable.Rows.Item(i).Cells.Item(1).Texts.Item(1).LeftIndent = "0p0"
oTable.Rows.Item(i).Cells.Item(1).Texts.Item(1).Hyphenation = False
oTable.Rows.Item(i).Cells.Item(1).BottomInset = "0p0"
oTable.Rows.Item(i).Cells.Item(1).TopInset = "0p0"
oTable.Rows.Item(i).Cells.Item(1).RightInset = "0p2"
oTable.Rows.Item(i).Cells.Item(1).LeftInset = "0p2"
oTable.Rows.Item(i).Cells.Item(1).VerticalJustification = idCenterVertical
...

HTH,

Max