ConnectionDataSourceType
ConnectionDataSourceType enumeration
Specifies external database source type
Values
| Name | Value | Description |
|---|---|---|
| ODBCBasedSource | 1 | ODBC-based source |
| DAOBasedSource | 2 | DAO-based source |
| FileBasedDataBaseSource | 3 | File based database source |
| WebQuery | 4 | Web query |
| OLEDBBasedSource | 5 | OLE DB-based source |
| TextBasedSource | 6 | Text-based source |
| ADORecordSet | 7 | ADO record set |
| DSP | 8 | DSP |
| OLEDBDataModel | 100 | OLE DB data source created by the Spreadsheet Data Model. |
| DataFeedDataModel | 101 | Data feed data source created by the Spreadsheet Data Model. |
| WorksheetDataModel | 102 | Worksheet data source created by the Spreadsheet Data Model. |
| Table | 102 | Worksheet data source created by the Spreadsheet Data Model. |
| TextDataModel | 103 | Text data source created by the Spreadsheet Data Model. |
| Unknown | 255 | Text data source created by the Spreadsheet Data Model. |