Workbooks.OpenDatabase(String, Object, Object, Object, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Returns a Workbook object representing a database.
public Microsoft.Office.Interop.Excel.Workbook OpenDatabase (string Filename, object CommandText, object CommandType, object BackgroundQuery, object ImportDataAs);Public Function OpenDatabase (Filename As String, Optional CommandText As Object, Optional CommandType As Object, Optional BackgroundQuery As Object, Optional ImportDataAs As Object) As WorkbookParameters
- Filename
- String
Required String. The connection string.
- CommandText
- Object
Optional Object. The command text of the query.
- CommandType
- Object
Optional Object. The command type of the query. The following command types are available: Default, SQL, and Table.
- BackgroundQuery
- Object
Optional Object. The background of the query.
- ImportDataAs
- Object
Optional Object. Determines the format of the query.