The Transact-SQL script Sqlwpub.sql installs the tables in a specified SQL Server database.
Table | Columns | Description |
SWPWorkbookFolder | FolderID | Identification number |
FolderPath | Path | |
FolderName | Name of workbook folder | |
SWPWorkbook | WorkbookID | Identification number |
FolderID | Folder that corresponds to workbook | |
Name | Name of workbook | |
Description | Description | |
Workbook | Workbook binary large object (BLOB) | |
Owner | Owner of workbook | |
LastModified | Date last modified | |
Protection | Whether workbook is public or private | |
SWPWorkbookSQL | SQLID | Identification number |
WorkbookID | Workbook that corresponds to query | |
Type | Format of Excel workbook: pivot table or worksheet | |
DSN | ODBC data source name information associated with the server | |
SQL | Transact-SQL script | |
Sheet | Location of sheet in Excel workbook | |
Location | Cell location of data in Excel sheet | |
LastModified | Date last modified | |