LoadDB Method
The LoadDB method is used to load the database.
Syntax
object.LoadDB( row, col, connect, SQL )
Parameter | Type | Description |
Row | Long | required, row where database data is to be inserted |
Col | Long | required, column where database data is to be inserted |
Connect | String | required, database connection string |
SQL | String | required, database options |
Example
This example demonstrates how to load a database into a new worksheet window.
Wks.LoadDB(1,1,"Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=DBQ=C:\GoldenData\ database.mdb;DefaultDir=C:\Data;Driver={Driver do Microsoft Access (*.mdb)};DriverId=281;FIL=MS Access;FILEDSN= C:\Data\new.dsn;MaxBufferSize=2048;MaxScanRows=8; PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin; UserCommitSync=Yes;","SELECT * FROM Category")
Used by: Worksheet object