Microsoft KB Articles for using ADO and Excel
From Support
Microsoft Knowledge Base articles can be found at: http://search.support.microsoft.com/kb/c.asp Choose to search by "specific article ID number" Enter the article number including the "Q"
dotNet
Q306022 HOW TO: Transfer Data to an Excel Workbook Using Visual Basic .NET
Q306572 HOW TO: Query and Display Excel Data Using ASP.NET, ADO.NET
Q307021 HOW TO: Transfer XML Data to Microsoft Excel 2002 with VB .NET
Q311731 HOW TO: Query and Display Excel Data Using ADO.NET, VB .NET
Q316756 PRB: Error Using ADO.Net OleDbDataAdapter to Modify Excel Workbook (pending)
Q316831 PRB: Cannot Configure Data Connections to Excel Files (pending)
Q316934 HOW TO: Use ADO.Net to Retrieve and Modify Records in an Excel
Workbook (pending)
Q317719 HOW TO: Display Data in Excel Using ASP.NET WebForm (pending)
Q318373 HOW TO: Use GetOleDbSchemaTable with Excel in Visual Basic .Net (pending)
General
Q257819 HOWTO: Use ADO with Excel Data from Visual Basic or VBA
Q303814 HOWTO: Use ADOX with Excel Data from Visual Basic or VBA
Q278973 SAMPLE: ExcelADO Shows How to Read/Write Data in Excel Workbooks
Q195951 HOWTO: Query and Update Excel Data Using ADO From ASP
Q306397 INFO: Use Excel with SQL Server Linked Servers and Distributed Queries
Known Issues
Q189897 XL97: Data Truncated to 255 Characters with Excel ODBC Driver (Rows
To Scan)
Q194124 PRB: Excel Values Returned as NULL Using DAO OpenRecordset (mixed data types)
Q211378 XL2000: 'Could Not Decrypt File' Error with Password-Protected File
Q246167 PRB: Collating Sequence Error Opening XLS as ADO Recordset
Q288343 BUG: Excel ODBC Driver Disregards FirstRowHasNames/HDR Setting
Q281517 PRB: Transfer of Data from Jet 4.0 OLEDB Source Fails w/ Error (DTS & Excel)
Q293828 BUG: Excel File Size Grows When You Edit ADO Recordset
Q294410 ACC2002: Nulls Replaced w/ Next Field's Data Exporting to Excel
Q300948 BUG: Incorrect TABLE_TYPE Is Returned for Excel Worksheets
Q314763 FIX: ADO Inserts Data into Wrong Excel Columns
Q316809 BUG: No ADO Connection Error When Excel Workbook Is Not Found
Transferring Data into Excel
Q247412 INFO: Methods for Transferring Data to Excel from Visual Basic
Q295646 HOWTO: Transfer Data from ADO Data Source to Excel with ADO
Q246335 HOWTO: Transfer Data from ADO Recordset to Excel with Automation
Other How-To Subjects
Q244761 XL2000: How to Use ADO to Return Data to a ListBox or ComboBox
Q285891 HOWTO: Use VB or ASP to Create an XML Spreadsheet for Excel 2002
Q276488 HOWTO: Use ADODB.Stream to Read Binary Files to the Browser
Q199841 HOWTO: Display ASP Results Using Excel in IE with MIME Types
Q278976 HOWTO: Transform Excel XML Spreadsheet for Server-Side Use
Q302094 HOWTO: Fill/Retrieve Excel Data Using Arrays From VB .Net
Q307063 HOW TO: Write Binary Files to the Browser Using ASP.NET & VB
Known Issues Working within Excel
Q263498 BUG: Run-Time Error 5 Using Add Method of QueryTables Collection
Q215154 XL2000: Excel does not support OLE DB Data Links
Q228633 OFF2000: "Catastrophic Failure" Error Running Samples.xls Macro
Q291199 XL2002: "Invalid Use of New Keyword" Error Using ADODB Library
Q225059 XL2000: "Invalid Use of New Keyword" Error Using ADODB Library
