document.write('<div class="feedburnerFeedBlock" id="microsoft/kqwWa4g108qn3hu68738l28n0foe5k">');
document.write('<p class="feedTitle">Database Functions</p>');
document.write('<ul>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/23700" target="_blank" >Multiple Databases and Criteria in Database Functions</a></span>');
document.write('<div>You 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/162474" target="_blank" >XL97: DFunctions Return Errors When Database Has Too Many Rows</a></span>');
document.write('<div>In 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/160870" target="_blank" >ACC: VBA Functions Break in Database with Missing References</a></span>');
document.write('<div>If 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/216578" target="_blank" >XL2000: Calculation Differences Between the Office Spreadsheet and ...</a></span>');
document.write('<div>Database Functions Return Incorrect Result The database functions listed above may all return incorrect results when used in the Office Spreadsheet.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/208218" target="_blank" >ACC2000: VBA Functions Break in Database with Missing References</a></span>');
document.write('<div>If 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/61941" target="_blank" >Tips for Importing Lotus 1-2-3 Files to Excel</a></span>');
document.write('<div>However, database criteria ranges are evaluated differently when you extract data, find data, and use database functions. For example, a criteria of \"John\" finds only ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/179841" target="_blank" >XL2000: Tips for Importing Lotus 1-2-3 Files into Microsoft Excel</a></span>');
document.write('<div>However, 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/828125" target="_blank" >Excel statistical functions: DVAR, DVARP, DSTDEV, and DSTDEVP</a></span>');
document.write('<div>DVAR, 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/179030" target="_blank" >XL98: Dfunction Incorrectly Returns Zero</a></span>');
document.write('<div>Database functions include DCOUNT, DCOUNTA, DMAX, DMIN, DSUM, DPRODUCT, DAVERAGE, DSTDEV, DSTDEVP, DVAR, and DGET. These functions use three arguments: database, field, and ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/283806" target="_blank" >Visual Basic for Applications (VBA) functions break in a database with ...</a></span>');
document.write('<div>Describes 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/120870" target="_blank" >XL: Overview of ODBC Add-in Functions and Arguments</a></span>');
document.write('<div>In 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/192360" target="_blank" >XL98: Overview of ODBC Add-in Functions and Arguments</a></span>');
document.write('<div>In 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</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214289" target="_blank" >Description of ODBC add-in functions and arguments in Excel 2000</a></span>');
document.write('<div>In 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.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/192215" target="_blank" >XL98: Advanced Filter Does Not Detect Additions to List</a></span>');
document.write('<div>Microsoft 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/192222" target="_blank" >XL98: Some Worksheet Functions Do Not Allow Array Constants</a></span>');
document.write('<div>This problem occurs because the SUMIF(), COUNTIF(), and COUNTBLANK() functions use the same criteria-matching algorithm as the database functions, such as DSUM().</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214286" target="_blank" >XL: Some Worksheet Functions Do Not Allow Array Constants</a></span>');
document.write('<div>This behavior occurs because the SUMIF(), COUNTIF(), and COUNTBLANK() functions use the same criteria-matching algorithm as database functions, such as DSUM().</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/321686" target="_blank" >How to import data from Excel to SQL Server</a></span>');
document.write('<div>The 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].</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/183512" target="_blank" >How to Use Advanced Filter to Exclude Records</a></span>');
document.write('<div>You 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/124218" target="_blank" >Macro Examples Using XLODBC Functions</a></span>');
document.write('<div>XLODBC.XLA contains Visual Basic for Applications functions as well as Microsoft Excel ... SQLGetSchema(Chan, 7) \' Get the table names for the database on the ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb257075.aspx" target="_blank" >SQLGetSchema Function\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>For 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213996" target="_blank" >XL2000: Advanced Filter Does Not Detect Additions to List</a></span>');
document.write('<div>Microsoft 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214324" target="_blank" >HOW TO: Use Advanced Filter to Exclude Records in Excel 2000</a></span>');
document.write('<div>This 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/135796" target="_blank" >ODBC 2.0 Drivers Use the MID() Scalar Function</a></span>');
document.write('<div>... 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.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/185370" target="_blank" >XL98: Cannot Use Scalar Functions in Microsoft Query</a></span>');
document.write('<div>The 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.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb687899.aspx" target="_blank" >Multithreaded Recalculation in Excel 2007</a></span>');
document.write('<div>Any 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/183501" target="_blank" >XL98: How to Use Advanced Filter to Exclude Records</a></span>');
document.write('<div>You 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/238574" target="_blank" >XL2000: Types of Formatting and Features Preserved in Workbook Sent as ...</a></span>');
document.write('<div>Simple 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)</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/cc539928.aspx" target="_blank" >Building Excel 2007 and Excel Services Dashboards by Consuming Two ...</a></span>');
document.write('<div>This database represents a system that requires a separate logon and contains sales ... Excel Services User-Defined Functions; Office Development with Visual Studio</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213794" target="_blank" >XL2000: DDEREQUEST May Truncate the Results of a Query</a></span>');
document.write('<div>The 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/aa730921.aspx" target="_blank" >Improving Performance in Excel 2007</a></span>');
document.write('<div>This 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/152984" target="_blank" >How to Use STDDEV or STDDEVP with a PivotTable</a></span>');
document.write('<div>\"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</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/167179" target="_blank" >XL97: Returning Data with DAO to a Custom Worksheet Function</a></span>');
document.write('<div>... 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.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb225774.aspx" target="_blank" >WorksheetFunction Object Members</a></span>');
document.write('<div>Used 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.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/125898" target="_blank" >ODBC Examples from NT Help File Using NWind Data Source</a></span>');
document.write('<div>The 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213710" target="_blank" >XL2000: Returning Data with Data Access Objects (DAO) to a Custom ...</a></span>');
document.write('<div>With 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb257081.aspx" target="_blank" >SQLOpen Function\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>This example runs a query on the Northwind database. The result of the query, displayed ... Excel 2007 Excel 2007 Developer Reference Concepts Functions SQLOpen Function</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/184016" target="_blank" >XL98: \"INTERSOLV\" Licensing Error Using SQL Functions</a></span>');
document.write('<div>This problem may occur if you use any of the following functions in your Visual Basic macro to use an external database:</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/186119" target="_blank" >OFF97: How to Programmatically Hide and Unhide the Windows Taskbar</a></span>');
document.write('<div>To 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.)</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb257067.aspx" target="_blank" >SQLError Function\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>... an intentional error by attempting to open a connection to the Northwind database by ... Excel 2007 Excel 2007 Developer Reference Concepts Functions SQLError Function</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/956836" target="_blank" >Description of the Excel 2007 hotfix package (Excel.msp, Xlconv.msp ...</a></span>');
document.write('<div>The Microsoft Office Access database engine could not find the object \'Sheet1$\'. ... It takes several minutes to save .xlsb files that contain many VLOOKUP functions if ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/135570" target="_blank" >Using REQUEST With FieldCount DDE Topic Causes Macro Error</a></span>');
document.write('<div>A4: 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb257065.aspx" target="_blank" >SQLClose Function\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>This example runs a query on the Northwind database. The result of the query, displayed ... Excel 2007 Excel 2007 Developer Reference Concepts Functions SQLClose Function</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb257085.aspx" target="_blank" >SQLRequest Function\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>This example runs a query on the Northwind database. The result of the query, displayed ... Excel 2007 Excel 2007 Developer Reference Concepts Functions SQLRequest Function</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/210145" target="_blank" >ACC2000: How to Use Automation to Fill a List Box</a></span>');
document.write('<div>Start Microsoft Access, open the sample database Northwind.mdb or the sample project ... For more information about using functions to fill list boxes, click Microsoft Access Help ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/151278" target="_blank" >DDEREQUEST May Truncate Results</a></span>');
document.write('<div>The 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 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb257070.aspx" target="_blank" >SQLExecQuery Function\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>This example runs a query on the Northwind database. The result of the query, displayed ... Excel 2007 Excel 2007 Developer Reference Concepts Functions SQLExecQuery Function</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/273583" target="_blank" >How to optimize PivotTable performance in Excel 2000</a></span>');
document.write('<div>... the source data that it uses to perform aggregations and other PivotTable functions. ... When you select Microsoft Excel list or database or Multiple consolidation ranges as your ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/117364" target="_blank" >SQL.REQUEST and SQLREQUEST Function Syntax Differences</a></span>');
document.write('<div>Two functions in the XLODBC.XLA add-in, SQLRequest (Visual Basic function) and SQL ... for Windows 95, versions 7.0 and 97, filenames, passwords, table names, and database ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/818798" target="_blank" >Office 2000 programs prompt you to register after April 15, 2003</a></span>');
document.write('<div>... the Office Registration Wizard does not start and your Office program functions as ... point for Office 2000 (for example, C:\\Office2000), MSI File is the .msi database ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/240159" target="_blank" >Office 2000 ODBC driver vulnerability security update</a></span>');
document.write('<div>This vulnerability is related to the IISAM component of the ODBC database driver and ... ACC2000: Jet 4.0 Expression Can Execute Unsafe Visual Basic for Application Functions</div>');
document.write('</li>');
document.write('</ul>');
document.write(' <p class="fbsubscribelink"><a href="http://feeds.feedburner.com/microsoft/kqwW"><img border="0" src="http://www.feedburner.com/fb/i/icn/feed-icon-10x10.gif"/> Subscribe to this Feed</a></p>');
document.write(' <div id="creditfooter"><a href="http://www.feedburner.com" target="_blank"><img src="http://www.feedburner.com/fb/images/buzzboost-pwrd.gif" alt="Headlines by FeedBurner" style="border:0"/></a></div>');
document.write('</div>');