USING ADO AND ADO.NET WITH EXCEL: Resources and Known Issues
General
-------
Q326548 HOW TO: Use Jet OLE DB Provider 4.0 to Connect to ISAM Databases
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q326548
Q257819 HOWTO: Use ADO with Excel Data from Visual Basic or VBA
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q257819
Q303814 HOWTO: Use ADOX with Excel Data from Visual Basic or VBA
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q303814
Q278973 SAMPLE: ExcelADO Shows How to Read/Write Data in Excel Workbooks
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q278973
Q195951 HOWTO: Query and Update Excel Data Using ADO From ASP
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q195951
Transferring Data into Excel
----------------------------
Q247412 INFO: Methods for Transferring Data to Excel from Visual Basic
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q247412
Q295646 HOWTO: Transfer Data from ADO Data Source to Excel with ADO
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q295646
Q246335 HOWTO: Transfer Data from ADO Recordset to Excel with Automation
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q246335
Q319951 HOW TO: Transfer Data to Excel by Using SQL Server DTS
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319951
Q306125 HOW TO: Import Data from SQL Server into Microsoft Excel
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306125
Known Issues
------------
Q319998 BUG: Memory Leak When You Query Open Excel Worksheet with ADO
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319998
Q316809 BUG: No ADO Connection Error When Excel Workbook Is Not Found
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316809
Q314763 FIX: ADO Inserts Data into Wrong Columns in Excel
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q314763
Q316475 PRB: "Operation Must Use an Updateable Query" Error Message
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316475
Q300948 BUG: Incorrect TABLE_TYPE Is Returned for Excel Worksheets
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q300948
Q294410 ACC2002: Nulls Replaced w/ Next Field's Data Exporting to Excel
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q294410
Q293828 BUG: Excel File Size Grows When You Edit ADO Recordset
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q293828
Q288343 BUG: Excel ODBC Driver Disregards FirstRowHasNames/HDR Setting
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q288343
Q246167 PRB: Collating Sequence Error Opening XLS as ADO Recordset
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q246167
Q211378 XL2000: 'Could Not Decrypt File' Error with Password-Protected File
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q211378
Q194124 PRB: Excel Values Returned as NULL Using DAO OpenRecordset (mixed
data types)
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q194124
Q189897 XL97: Data Truncated to 255 Characters with Excel ODBC Driver (Rows
To Scan)
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q189897
Known Issues - .Net-specific
----------------------------
Q316831 PRB: Cannot Configure Data Connection to Excel Files in VS .NET
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316831
Q316756 PRB: Error w/ ADO.NET OLEDbDataAdapter to Modify Excel Workbook
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316756
VB.Net
------
Q318373 HOW TO: Use GetOleDbSchemaTable with Excel in Visual Basic .NET
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q318373
Q316934 HOW TO: Use ADO.NET to Retrieve and Modify Records in Excel
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316934
Q306022 HOW TO: Transfer Data to Excel Workbook Using Visual Basic .NET
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306022
Q302094 HOWTO: Fill/Retrieve Excel Data Using Arrays From VB .Net
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q302094
Web/ASP
-------
Q319180 HOWTO: Transform Dataset to Spreadsheet XML for Microsoft Excel
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319180
Q276488 HOWTO: Use ADODB.Stream to Read Binary Files to the Browser
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q276488
Q257757 INFO: Considerations for Server-Side Automation of Office
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q257757
Q199841 HOWTO: Display ASP Results Using Excel in IE with MIME Types
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q199841
Q195951 HOWTO: Query and Update Excel Data Using ADO From ASP
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q195951
Web/ASP.Net - .Net-specific
---------------------------
Q317719 HOW TO: Export Data in DataGrid on an ASP. NET WebForm to Excel
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q317719
Q311731 HOW TO: Query and Display Excel Data by Using ADO.NET, VB .NET
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q311731
Q308247 HOW TO: Use ASP.NET to Query and Display Database Data in Excel
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q308247
Q307603 HOW TO: Write Binary Files to the Browser Using ASP.NET & VB
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q307603
SQL Server/DTS
--------------
Q321686 HOW TO: Import Data into SQL Server from Excel
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q321686
Q319951 HOW TO: Transfer Data to Excel by Using SQL Server DTS
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319951
Q306397 HOWTO: Use Excel w/ SQL Linked Servers & Distributed Queries
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306397
Q306125 HOW TO: Import Data from SQL Server into Microsoft Excel
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306125
Q281517 PRB: Transfer of Data from Jet 4.0 OLEDB Source Fails w/ Error
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q281517
Q257757 INFO: Considerations for Server-Side Automation of Office
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q257757
Q236605 PRB: DTS Wizard May not Detect Excel Column Type for Mixed Data
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q236605
Q231880 BUG: Import Wizard Fails if Excel File Open During Import/Export
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q231880t
Q207446 BUG: Cannot Import Excel 97 Spreadsheet with 256 or More Columns
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q207446
XML
---
Q285891 HOWTO: Use VB or ASP to Create an XML Spreadsheet for Excel 2002
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q285891
Q278976 HOWTO: Transform Excel XML Spreadsheet for Server-Side Use
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q278976
XML - .Net-specific
-------------------
Q319180 HOWTO: Transform Dataset to Spreadsheet XML for Microsoft Excel
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319180
Q307021 HOW TO: Transfer XML Data to Microsoft Excel 2002 with VB .NET
https://support.microsoft.com/default.aspx?scid=kb;EN-US;Q307021
Comments
- Anonymous
May 17, 2006
Published new article..about ways, and issues associated with using ADO with excel, initially I published...