{"version":"1.0","type":"rich","title":"Gist 40be33d9a867660bd732","description":"This example shows how to export every user table from an Access database to a single Excel workbook. The VBA macro iterates through all table definitions, skipping system tables whose names start with “MSys.” For each remaining table, it calls `DoCmd.TransferSpreadsheet` to export the table’s data into the file `excel_out.xls`, using the `acSpreadsheetTypeExcel9` format. It replaces the `dbo_` prefix in table names when creating the destination worksheet names. The output file path is derived from the current project’s directory.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-40be33d9a867660bd732?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}