Use Msdn to search the Web.http://feedproxy.google.com/~r/microsoft/kqwW/~3/CQvdhjI3-s4/23700You can specify more than one database and/or criteria for use with the database functions [DSUM(), DCOUNT(), and so on] in Microsoft Excel. The database functions will accept any ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/CQvdhjI3-s4" height="1" width="1"/>http://support.microsoft.com/kb/23700http://feedproxy.google.com/~r/microsoft/kqwW/~3/CrcxlOHdezo/160870If you have a procedure that contains a Visual Basic for Applications function, and your database contains a reference to a missing object library or type library, you may receive ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/CrcxlOHdezo" height="1" width="1"/>http://support.microsoft.com/kb/160870http://feedproxy.google.com/~r/microsoft/kqwW/~3/ZTOwbe-UKGQ/162474In Microsoft Excel 97, when you type a formula that contains any of the worksheet database functions (also known as DFunctions), the formula returns either an error value or an ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/ZTOwbe-UKGQ" height="1" width="1"/>http://support.microsoft.com/kb/162474http://feedproxy.google.com/~r/microsoft/kqwW/~3/jHXB29hSey4/208218If you have a procedure that contains a Visual Basic for Applications function, and your database contains a reference to a missing object library or type library, you may receive ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/jHXB29hSey4" height="1" width="1"/>http://support.microsoft.com/kb/208218http://feedproxy.google.com/~r/microsoft/kqwW/~3/DmpsKtEUd6M/283806Describes the error messages that you may receive when you compile modules or run a procedure. Problem occurs if the procedure contains a VBA function and if your database contains ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/DmpsKtEUd6M" height="1" width="1"/>http://support.microsoft.com/kb/283806http://feedproxy.google.com/~r/microsoft/kqwW/~3/DlomyVyGl2Q/216578Database Functions Return Incorrect Result The database functions listed above may all return incorrect results when used in the Office Spreadsheet.<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/DlomyVyGl2Q" height="1" width="1"/>http://support.microsoft.com/kb/216578http://feedproxy.google.com/~r/microsoft/kqwW/~3/A-Qb8rQ7YYI/828125DVAR, DVARP, DSTDEV, and DSTDEVP take as arguments a database, a field, and criteria. The functions take as observations the field values in each database record that ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/A-Qb8rQ7YYI" height="1" width="1"/>http://support.microsoft.com/kb/828125http://feedproxy.google.com/~r/microsoft/kqwW/~3/WTyb1bx3bkQ/179841However, database criteria ranges are evaluated differently when you extract data, find data, and use database functions. For example, a criteria of "John" finds only rows with ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/WTyb1bx3bkQ" height="1" width="1"/>http://support.microsoft.com/kb/179841http://feedproxy.google.com/~r/microsoft/kqwW/~3/N75BpB9lVj0/192215Microsoft Excel automatically recognizes your list as a database. Because of this behavior, it is not necessary to define the range for your database. Functions such as sorting ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/N75BpB9lVj0" height="1" width="1"/>http://support.microsoft.com/kb/192215http://feedproxy.google.com/~r/microsoft/kqwW/~3/U4vNz7CZsqg/192222This problem occurs because the SUMIF(), COUNTIF(), and COUNTBLANK() functions use the same criteria-matching algorithm as the database functions, such as DSUM().<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/U4vNz7CZsqg" height="1" width="1"/>http://support.microsoft.com/kb/192222http://feedproxy.google.com/~r/microsoft/kqwW/~3/NLmGCRSq-nQ/214286This behavior occurs because the SUMIF(), COUNTIF(), and COUNTBLANK() functions use the same criteria-matching algorithm as database functions, such as DSUM().<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/NLmGCRSq-nQ" height="1" width="1"/>http://support.microsoft.com/kb/214286http://feedproxy.google.com/~r/microsoft/kqwW/~3/sePfOyeN6_4/179030Database functions include DCOUNT, DCOUNTA, DMAX, DMIN, DSUM, DPRODUCT, DAVERAGE, DSTDEV, DSTDEVP, DVAR, and DGET. These functions use three arguments: database, field, and ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/sePfOyeN6_4" height="1" width="1"/>http://support.microsoft.com/kb/179030http://feedproxy.google.com/~r/microsoft/kqwW/~3/M5BXcT-IZNw/192360In Microsoft Excel 98 Macintosh Edition, the XLODBC.XLA ODBC add-in provides Open Database Connectivity (ODBC) functions that allow you to connect to external data sources directly<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/M5BXcT-IZNw" height="1" width="1"/>http://support.microsoft.com/kb/192360http://feedproxy.google.com/~r/microsoft/kqwW/~3/c4YjClGuJ8U/61941However, database criteria ranges are evaluated differently when you extract data, find data, and use database functions. For example, a criteria of "John" finds only ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/c4YjClGuJ8U" height="1" width="1"/>http://support.microsoft.com/kb/61941http://feedproxy.google.com/~r/microsoft/kqwW/~3/PhOGtJFudHY/183512You can use the ISNA and MATCH worksheet functions exclude records in an Excel database that do not match another list. To create exclusion criteria, use the following formula ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/PhOGtJFudHY" height="1" width="1"/>http://support.microsoft.com/kb/183512http://feedproxy.google.com/~r/microsoft/kqwW/~3/hUevsKK7WuY/321686The Jet database engine can reference external databases in SQL statements by using a special syntax that has three different formats: [Full path to Microsoft Access database].<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/hUevsKK7WuY" height="1" width="1"/>http://support.microsoft.com/kb/321686http://feedproxy.google.com/~r/microsoft/kqwW/~3/FOUpLuBZw2k/120870In the versions of Microsoft Excel listed at the beginning of this article, the XLODBC.XLA ODBC add-in provides Open Database Connectivity (ODBC) functions that allow you to ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/FOUpLuBZw2k" height="1" width="1"/>http://support.microsoft.com/kb/120870http://feedproxy.google.com/~r/microsoft/kqwW/~3/7TFtyX_9oss/124218XLODBC.XLA contains Visual Basic for Applications functions as well as Microsoft Excel ... SQLGetSchema(Chan, 7) ' Get the table names for the database on the ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/7TFtyX_9oss" height="1" width="1"/>http://support.microsoft.com/kb/124218http://feedproxy.google.com/~r/microsoft/kqwW/~3/TjLHjAyumQU/213996Microsoft Excel 2000 automatically recognizes your list as a database. Because of this behavior, it is not necessary to define the range for your database. Functions such as ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/TjLHjAyumQU" height="1" width="1"/>http://support.microsoft.com/kb/213996http://feedproxy.google.com/~r/microsoft/kqwW/~3/bMVi1VIyVVc/214324This step-by-step article explains how to use the ISNA and MATCH worksheet functions to exclude records in a Microsoft Excel database that do not match another list. How to Create ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/bMVi1VIyVVc" height="1" width="1"/>http://support.microsoft.com/kb/214324http://feedproxy.google.com/~r/microsoft/kqwW/~3/HDP_VM8fbL4/135796... Open Database Connectivity (ODBC) drivers shipped in the Microsoft ODBC Desktop Database ... and then double-click the selected text to go to the "Scalar Functions" topic.<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/HDP_VM8fbL4" height="1" width="1"/>http://support.microsoft.com/kb/135796http://feedproxy.google.com/~r/microsoft/kqwW/~3/qrCS7-osw24/214289In Microsoft Excel 2000, the Xlodbc.xla ODBC add-in provides Open Database Connectivity (ODBC) functions that allow you to connect to external data sources directly.<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/qrCS7-osw24" height="1" width="1"/>http://support.microsoft.com/kb/214289http://feedproxy.google.com/~r/microsoft/kqwW/~3/Cqe7giZxLew/bb257075.aspxFor example, "database procedure ... uses the ODBC API functions SQLGetInfo and SQLTables to find the requested information. Example. This example retrieves the database name and DBMS ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/Cqe7giZxLew" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb257075.aspxhttp://feedproxy.google.com/~r/microsoft/kqwW/~3/2zHU_U0G7w8/185370The ability to use scalar functions in a query is dependent on the functionality that is provided by the Open Database Connectivity (ODBC) driver that you are using.<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/2zHU_U0G7w8" height="1" width="1"/>http://support.microsoft.com/kb/185370http://feedproxy.google.com/~r/microsoft/kqwW/~3/laJwcws-4fc/183501You can use the ISNA and MATCH worksheet functions exclude records in an Excel database that do not match another list. To create exclusion criteria, use the following formula ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/laJwcws-4fc" height="1" width="1"/>http://support.microsoft.com/kb/183501http://feedproxy.google.com/~r/microsoft/kqwW/~3/jEKNqCCdXp4/152984"Microsoft Excel list or database" should be the default option selected. ... Excel, click Answer Wizard on the Help menu and type: pivot table summary functions<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/jEKNqCCdXp4" height="1" width="1"/>http://support.microsoft.com/kb/152984http://feedproxy.google.com/~r/microsoft/kqwW/~3/SC3uPs7mPnc/bb687899.aspxAny database function (DSUM, DAVERAGE, and so on) that refers to a pivot table ... Any XLL that exports worksheet functions can take advantage of multithreaded recalculation ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/SC3uPs7mPnc" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb687899.aspxhttp://feedproxy.google.com/~r/microsoft/kqwW/~3/ZLPzR2P4xT8/cc539928.aspxThis database represents a system that requires a separate logon and contains sales ... Excel Services User-Defined Functions. Office Development with Visual Studio<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/ZLPzR2P4xT8" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/cc539928.aspxhttp://feedproxy.google.com/~r/microsoft/kqwW/~3/imUlfrOGTpw/186119To create the functions and to see how they work, follow these steps: Press ALT+F11 to start the Visual Basic Editor (or in Microsoft Access, open a database.)<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/imUlfrOGTpw" height="1" width="1"/>http://support.microsoft.com/kb/186119http://feedproxy.google.com/~r/microsoft/kqwW/~3/fJjKhmjKZTw/213710With Microsoft Excel, you can create custom functions using Visual Basic for Applications ... the Data Access Objects component of Microsoft Office and the Northwind database files ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/fJjKhmjKZTw" height="1" width="1"/>http://support.microsoft.com/kb/213710http://feedproxy.google.com/~r/microsoft/kqwW/~3/z7wSqgv9KKk/167179... you to create custom functions using Visual Basic for Applications. You can also use Data Access Objects (DAO) to programmatically return information from an external database.<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/z7wSqgv9KKk" height="1" width="1"/>http://support.microsoft.com/kb/167179http://feedproxy.google.com/~r/microsoft/kqwW/~3/KjjJKy5YEM8/bb257067.aspx... an intentional error by attempting to open a connection to the Northwind database by ... Excel 2007 Excel 2007 Developer Reference Concepts Functions SQLError Function<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/KjjJKy5YEM8" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb257067.aspxhttp://feedproxy.google.com/~r/microsoft/kqwW/~3/4FKNyJhbiV8/125898The following examples show how to use each of the SQL Functions in a Visual Basic ... This example runs a query on the NWind sample database. The result of the query ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/4FKNyJhbiV8" height="1" width="1"/>http://support.microsoft.com/kb/125898http://feedproxy.google.com/~r/microsoft/kqwW/~3/DxJ7rZZ5PmI/238574Simple formulas including cell references and worksheet functions; Database queries (you cannot edit a query once the message is sent, but you can refresh the query)<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/DxJ7rZZ5PmI" height="1" width="1"/>http://support.microsoft.com/kb/238574http://feedproxy.google.com/~r/microsoft/kqwW/~3/ZupbLdwshFE/202099To create the functions and to see how they work, follow these steps: Press ALT+F11 to ... Option Compare Database Option Explicit Dim handleW1 As Long Private Declare ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/ZupbLdwshFE" height="1" width="1"/>http://support.microsoft.com/kb/202099http://feedproxy.google.com/~r/microsoft/kqwW/~3/dNC0Mt2DIpc/bb225774.aspxUsed as a container for Microsoft Excel worksheet functions that can be called from Visual ... Averages the values in a column of a list or database that match conditions you specify.<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/dNC0Mt2DIpc" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb225774.aspxhttp://feedproxy.google.com/~r/microsoft/kqwW/~3/tqLIkMn-5NE/bb257065.aspxThis example runs a query on the Northwind database. The result of the query, displayed ... Excel 2007 Excel 2007 Developer Reference Concepts Functions SQLClose Function<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/tqLIkMn-5NE" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb257065.aspxhttp://feedproxy.google.com/~r/microsoft/kqwW/~3/v-ev6h4ha1U/bb257081.aspxThis example runs a query on the Northwind database. The result of the query, displayed ... Excel 2007 Excel 2007 Developer Reference Concepts Functions SQLOpen Function<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/v-ev6h4ha1U" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb257081.aspxhttp://feedproxy.google.com/~r/microsoft/kqwW/~3/RaPES5ICOOg/184016This problem may occur if you use any of the following functions in your Visual Basic macro to use an external database:<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/RaPES5ICOOg" height="1" width="1"/>http://support.microsoft.com/kb/184016http://feedproxy.google.com/~r/microsoft/kqwW/~3/a6QJnB9WXws/135570A4: Specify the directory and file name of the database to use. A5: Initiate a channel to ... For more information on SQL Functions, search for one of the following topics in the ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/a6QJnB9WXws" height="1" width="1"/>http://support.microsoft.com/kb/135570http://feedproxy.google.com/~r/microsoft/kqwW/~3/AGxjYm1-RoA/aa730921.aspxThis is useful if, for example, you have XLL user-defined functions dependent on long-running external calls to a database server. If the database server can process multiple ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/AGxjYm1-RoA" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa730921.aspxhttp://feedproxy.google.com/~r/microsoft/kqwW/~3/yaqyVbnv-io/834691This update fixes the problem so that these functions generate the correct results. ... point for Office 2003 (for example, C:\Office2003), MSI File is the .msi database ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/yaqyVbnv-io" height="1" width="1"/>http://support.microsoft.com/kb/834691http://feedproxy.google.com/~r/microsoft/kqwW/~3/oJvWm5GVXpY/328933When you copy numbers from a Microsoft Access 2002 database and paste them into ... as numbers, but sorts as text and are not available for formulas and functions.<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/oJvWm5GVXpY" height="1" width="1"/>http://support.microsoft.com/kb/328933http://feedproxy.google.com/~r/microsoft/kqwW/~3/WRGwrceh1vo/bb257062.aspxThis example runs a query on the Northwind database, and then it uses the SQLBind function ... Excel 2007 Excel 2007 Developer Reference Concepts Functions SQLBind Function<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/WRGwrceh1vo" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb257062.aspxhttp://feedproxy.google.com/~r/microsoft/kqwW/~3/jxueh_pVfGM/104308... of the source data that is used to perform aggregations and other PivotTable functions. ... When you use Microsoft Excel List Or Database or Multiple Consolidation Ranges as your ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/jxueh_pVfGM" height="1" width="1"/>http://support.microsoft.com/kb/104308http://feedproxy.google.com/~r/microsoft/kqwW/~3/HAQc9AvQrcU/bb257070.aspxThis example runs a query on the Northwind database. The result of the query, displayed ... Excel 2007 Excel 2007 Developer Reference Concepts Functions SQLExecQuery Function<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/HAQc9AvQrcU" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb257070.aspxhttp://feedproxy.google.com/~r/microsoft/kqwW/~3/0CS0KVrVKFI/213794The array form of these functions parses the SQL statement into array elements. ... Give the user control in Microsoft Query so they can select data ' from a database ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/0CS0KVrVKFI" height="1" width="1"/>http://support.microsoft.com/kb/213794http://feedproxy.google.com/~r/microsoft/kqwW/~3/CXQ9MGmOOz4/bb257091.aspxThis example runs a query on the Northwind database. The result of the query, which is a ... Excel 2007 Developer Reference Concepts Functions SQLRetrieveToFile Function<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/CXQ9MGmOOz4" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb257091.aspxhttp://feedproxy.google.com/~r/microsoft/kqwW/~3/lm_pBtRF5QE/151278The array form of these functions parses the SQL statement into array elements. ... Give the user control in Microsoft Query so they can select data ' from a database ...<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/lm_pBtRF5QE" height="1" width="1"/>http://support.microsoft.com/kb/151278http://feedproxy.google.com/~r/microsoft/kqwW/~3/9IlrCEMCFYQ/bb257085.aspxThis example runs a query on the Northwind database. The result of the query, displayed ... Excel 2007 Excel 2007 Developer Reference Concepts Functions SQLRequest Function<img src="http://feeds.feedburner.com/~r/microsoft/kqwW/~4/9IlrCEMCFYQ" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb257085.aspx