Option Explicit Dim Db As Database Dim Rs As RecordsetPrivate Sub Form_Load() Set Db = OpenDatabase("c:\temp\book1.xls", False, False, "Excel 8.0;") Set Rs = Db.OpenRecordset("sheet1$") End SubPrivate Sub Form_Unload(Cancel As Integer) Rs.Close Db.Close End Sub
我记得还有个WORKSPACE吧，你看MSDN啊，很多的
OpenDatabase Method [This is preliminary documentation and subject to change.] This is the OpenDatabase method of the MsiInstall object. This method opens an existing database or creates a new one, returning an MsiDatabase object. It generates an error if the database object cannot be successfully created and opened.Syntax object.OpenDatabase(name, openMode)Parts object MsiInstall object. name Required string containing the path name of the database. If an empty string is supplied, a temporary database is created that is not persisted. openMode Required enum from the following listed or a string containing the path name of the new output database file to be written to upon commit. idoReadOnly = 0 Open database read-only; no persisted changes. idoTransact = 1 Open database; read-write in transaction mode. idoDirect = 2 Open database direct; read-write without transaction. idoCreate = 3 Create new database; read-write in transaction mode. idoCreateDirect = 4 Create new database; read-write without transaction mode. Res Database SpecificationsThe database type is determined by examining path and file content as specified below:An MSI package if a doc file with the correct CLSID, .msi extension is typical.Note When a database is opened as the output of another database, the summary information stream of the output database is actually a read-only mirror of the original database and thus cannot be changed. Additionally, it will not be persisted with the database. To create or modify the summary information for the output database it must be closed and re-opened.
错了,应该是这个 ^_^ OpenDatabase Method Opens a specified database in a Workspace object and returns a reference to the Database object that represents it. SyntaxSet database = workspace.OpenDatabase (dbname, options, read-only, connect)The OpenDatabase method syntax has these parts.Part Description database An object variable that represents the Database object that you want to open. workspace Optional. An object variable that represents the existing Workspace object that will contain the database. If you don't include a value for workspace, OpenDatabase uses the default workspace. dbname A String that is the name of an existing Microsoft Jet database file, or the data source name (DSN) of an ODBC data source. See the Name property for more information about setting this value. options Optional. A Variant that sets various options for the database, as specified in Settings. read-only Optional. A Variant (Boolean subtype) value that is True if you want to open the database with read-only access, or False (default) if you want to open the database with read/write access. connect Optional. A Variant (String subtype) that specifies various connection information, including passwords. SettingsFor Microsoft Jet workspaces, you can use the following values for the options argument. Setting Description True Opens the database in exclusive mode. False (Default) Opens the database in shared mode. For ODBCDirect workspaces, the options argument determines if and when to prompt the user to establish the connection. You can use one of the following constants.Constant Description dbDriverNoPrompt The ODBC Driver Manager uses the connection string provided in dbname and connect. If you don't provide sufficient information, a run-time error occurs. dbDriverPrompt The ODBC Driver Manager displays the ODBC Data Sources dialog box, which displays any relevant information supplied in dbname or connect. The connection string is made up of the DSN that the user selects via the dialog boxes, or, if the user doesn't specify a DSN, the default DSN is used. dbDriverComplete (Default) If the connect and dbname arguments include all the necessary information to complete a connection, the ODBC Driver Manager uses the string in connect. Otherwise it behaves as it does when you specify dbDriverPrompt. dbDriverCompleteRequired This option behaves like dbDriverComplete except the ODBC driver disables the prompts for any information not required to complete the connection. ResWhen you open a database, it is automatically added to the Databases collection. Further, in an ODBCDirect workspace, the Connection object corresponding to the new Database object is also created and appended to the Connections collection of the same Workspace object.Some considerations apply when you use dbname: If it refers to a database that is already open for exclusive access by another user, an error occurs. If it doesn't refer to an existing database or valid ODBC data source name, an error occurs. If it's a zero-length string ("") and connect is "ODBC;", a dialog box listing all registered ODBC data source names is displayed so the user can select a database. If you're opening a database through an ODBCDirect workspace and you provide the DSN in connect, you can set dbname to a string of your choice that you can use to reference this database in subsequent code. The connect argument is expressed in two parts: the database type, followed by a semicolon (;) and the optional arguments. You must first provide the database type, such as "ODBC;" or "FoxPro 2.5;". The optional arguments follow in no particular order, separated by semicolons. One of the parameters may be the password (if one is assigned). For example: "FoxPro 2.5; pwd=mypassword"Using the NewPassword method on a Database object other than an ODBCDirect database changes the password parameter that appears in the ";pwd=..." part of this argument. You must supply the options and read-only arguments to supply a source string. See the Connect property for syntax.To close a database, and thus remove the Database object from the Databases collection, use the Close method on the object.Note When you access a Microsoft Jet-connected ODBC data source, you can improve your application's performance by opening a Database object connected to the ODBC data source, rather than by linking individual TableDef objects to specific tables in the ODBC data source.
Dim Db As Database
Dim Rs As RecordsetPrivate Sub Form_Load()
Set Db = OpenDatabase("c:\temp\book1.xls", False, False, "Excel 8.0;")
Set Rs = Db.OpenRecordset("sheet1$")
End SubPrivate Sub Form_Unload(Cancel As Integer)
Rs.Close
Db.Close
End Sub
[This is preliminary documentation and subject to change.] This is the OpenDatabase method of the MsiInstall object. This method opens an existing database or creates a new one, returning an MsiDatabase object. It generates an error if the database object cannot be successfully created and opened.Syntax
object.OpenDatabase(name, openMode)Parts
object
MsiInstall object.
name
Required string containing the path name of the database. If an empty string is supplied, a temporary database is created that is not persisted.
openMode
Required enum from the following listed or a string containing the path name of the new output database file to be written to upon commit. idoReadOnly = 0 Open database read-only; no persisted changes.
idoTransact = 1 Open database; read-write in transaction mode.
idoDirect = 2 Open database direct; read-write without transaction.
idoCreate = 3 Create new database; read-write in transaction mode.
idoCreateDirect = 4 Create new database; read-write without transaction mode.
Res
Database SpecificationsThe database type is determined by examining path and file content as specified below:An MSI package if a doc file with the correct CLSID, .msi extension is typical.Note When a database is opened as the output of another database, the summary information stream of the output database is actually a read-only mirror of the original database and thus cannot be changed. Additionally, it will not be persisted with the database. To create or modify the summary information for the output database it must be closed and re-opened.
OpenDatabase Method
Opens a specified database in a Workspace object and returns a reference to the Database object that represents it. SyntaxSet database = workspace.OpenDatabase (dbname, options, read-only, connect)The OpenDatabase method syntax has these parts.Part Description
database An object variable that represents the Database object that you want to open.
workspace Optional. An object variable that represents the existing Workspace object that will contain the database. If you don't include a value for workspace, OpenDatabase uses the default workspace.
dbname A String that is the name of an existing Microsoft Jet database file, or the data source name (DSN) of an ODBC data source. See the Name property for more information about setting this value.
options Optional. A Variant that sets various options for the database, as specified in Settings.
read-only Optional. A Variant (Boolean subtype) value that is True if you want to open the database with read-only access, or False (default) if you want to open the database with read/write access.
connect Optional. A Variant (String subtype) that specifies various connection information, including passwords.
SettingsFor Microsoft Jet workspaces, you can use the following values for the options argument. Setting Description
True Opens the database in exclusive mode.
False (Default) Opens the database in shared mode.
For ODBCDirect workspaces, the options argument determines if and when to prompt the user to establish the connection. You can use one of the following constants.Constant Description
dbDriverNoPrompt The ODBC Driver Manager uses the connection string provided in dbname and connect. If you don't provide sufficient information, a run-time error occurs.
dbDriverPrompt The ODBC Driver Manager displays the ODBC Data Sources dialog box, which displays any relevant information supplied in dbname or connect. The connection string is made up of the DSN that the user selects via the dialog boxes, or, if the user doesn't specify a DSN, the default DSN is used.
dbDriverComplete (Default) If the connect and dbname arguments include all the necessary information to complete a connection, the ODBC Driver Manager uses the string in connect. Otherwise it behaves as it does when you specify dbDriverPrompt.
dbDriverCompleteRequired This option behaves like dbDriverComplete except the ODBC driver disables the prompts for any information not required to complete the connection.
ResWhen you open a database, it is automatically added to the Databases collection. Further, in an ODBCDirect workspace, the Connection object corresponding to the new Database object is also created and appended to the Connections collection of the same Workspace object.Some considerations apply when you use dbname: If it refers to a database that is already open for exclusive access by another user, an error occurs.
If it doesn't refer to an existing database or valid ODBC data source name, an error occurs.
If it's a zero-length string ("") and connect is "ODBC;", a dialog box listing all registered ODBC data source names is displayed so the user can select a database.
If you're opening a database through an ODBCDirect workspace and you provide the DSN in connect, you can set dbname to a string of your choice that you can use to reference this database in subsequent code.
The connect argument is expressed in two parts: the database type, followed by a semicolon (;) and the optional arguments. You must first provide the database type, such as "ODBC;" or "FoxPro 2.5;". The optional arguments follow in no particular order, separated by semicolons. One of the parameters may be the password (if one is assigned). For example: "FoxPro 2.5; pwd=mypassword"Using the NewPassword method on a Database object other than an ODBCDirect database changes the password parameter that appears in the ";pwd=..." part of this argument. You must supply the options and read-only arguments to supply a source string. See the Connect property for syntax.To close a database, and thus remove the Database object from the Databases collection, use the Close method on the object.Note When you access a Microsoft Jet-connected ODBC data source, you can improve your application's performance by opening a Database object connected to the ODBC data source, rather than by linking individual TableDef objects to specific tables in the ODBC data source.