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