----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Suresh[MS MVP] Message 2 in Discussion Hello Arun, Here is few links i found from net , General ------- Q257819 HOWTO: Use ADO with Excel Data from Visual Basic or VBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q257819 Q303814 HOWTO: Use ADOX with Excel Data from Visual Basic or VBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q303814 Q278973 SAMPLE: ExcelADO Shows How to Read/Write Data in Excel Workbooks http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q278973 Q195951 HOWTO: Query and Update Excel Data Using ADO From ASP http://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 http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q247412 Q295646 HOWTO: Transfer Data from ADO Data Source to Excel with ADO http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q295646 Q246335 HOWTO: Transfer Data from ADO Recordset to Excel with Automation http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q246335 Q319951 HOW TO: Transfer Data to Excel by Using SQL Server DTS http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319951 Q306125 HOW TO: Import Data from SQL Server into Microsoft Excel http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306125 Known Issues (most recent listed first) ------------ Q319998 BUG: Memory Leak When You Query Open Excel Worksheet with ADO http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319998 Q316831 PRB: Cannot Configure Data Connection to Excel Files in VS .NET http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316831 Q316809 BUG: No ADO Connection Error When Excel Workbook Is Not Found http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316809 Q316756 PRB: Error w/ ADO.NET OLEDbDataAdapter to Modify Excel Workbook http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316756 Q314763 FIX: ADO Inserts Data into Wrong Columns in Excel http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q314763 Q316475 PRB: "Operation Must Use an Updateable Query" Error Message http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316475 Q300948 BUG: Incorrect TABLE_TYPE Is Returned for Excel Worksheets http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q300948 Q294410 ACC2002: Nulls Replaced w/ Next Field's Data Exporting to Excel Q293828 BUG: Excel File Size Grows When You Edit ADO Recordset http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q293828 Q288343 BUG: Excel ODBC Driver Disregards FirstRowHasNames/HDR Setting http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q288343 Q246167 PRB: Collating Sequence Error Opening XLS as ADO Recordset http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q246167 Q211378 XL2000: 'Could Not Decrypt File' Error with Password-Protected File Q194124 PRB: Excel Values Returned as NULL Using DAO OpenRecordset (mixed data types) Q189897 XL97: Data Truncated to 255 Characters with Excel ODBC Driver (Rows To Scan) VB/VB.Net (most recent listed first) --------- Q319180 HOWTO: Transform Dataset to Spreadsheet XML for Microsoft Excel http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319180 Q318373 HOW TO: Use GetOleDbSchemaTable with Excel in Visual Basic .NET http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q318373 Q316934 HOW TO: Use ADO.NET to Retrieve and Modify Records in Excel http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q316934 Q311731 HOW TO: Query and Display Excel Data by Using ADO.NET, VB .NET http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q311731 Q306022 HOW TO: Transfer Data to Excel Workbook Using Visual Basic .NET http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306022 Q302094 HOWTO: Fill/Retrieve Excel Data Using Arrays From VB .Net ASP/ASP.Net/Web (most recent listed first) --------------- Q317719 HOW TO: Export Data in DataGrid on an ASP. NET WebForm to Excel http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q317719 Q308247 HOW TO: Use ASP.NET to Query and Display Database Data in Excel http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q308247 Q307603 HOW TO: Write Binary Files to the Browser Using ASP.NET & VB http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q307603 Q306572 HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306572 Q276488 HOWTO: Use ADODB.Stream to Read Binary Files to the Browser http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q276488 Q257757 INFO: Considerations for Server-Side Automation of Office http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q257757 Q199841 HOWTO: Display ASP Results Using Excel in IE with MIME Types http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q199841 Q195951 HOWTO: Query and Update Excel Data Using ADO From ASP http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q195951 SQL Server/DTS (most recent listed first) -------------- Q321686 HOW TO: Import Data into SQL Server from Excel http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q321686 Q319951 HOW TO: Transfer Data to Excel by Using SQL Server DTS http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319951 Q306397 HOWTO: Use Excel w/ SQL Linked Servers & Distributed Queries http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306397 Q306125 HOW TO: Import Data from SQL Server into Microsoft Excel http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306125 Q281517 PRB: Transfer of Data from Jet 4.0 OLEDB Source Fails w/ Error http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q281517 Q236605 PRB: DTS Wizard May not Detect Excel Column Type for Mixed Data http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q236605 Q231880 BUG: Import Wizard Fails if Excel File Open During Import/Export http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q231880t Q207446 BUG: Cannot Import Excel 97 Spreadsheet with 256 or More Columns http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q207446 XML (most recent listed first) --- Q319180 HOWTO: Transform Dataset to Spreadsheet XML for Microsoft Excel http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319180 Q307021 HOW TO: Transfer XML Data to Microsoft Excel 2002 with VB .NET http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q307021 Q285891 HOWTO: Use VB or ASP to Create an XML Spreadsheet for Excel 2002 http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q285891 Q278976 HOWTO: Transform Excel XML Spreadsheet for Server-Side Use http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q278976 ADO within Excel (most recent listed first) ---------------- Q291199 XL2002: "Invalid Use of New Keyword" Error Using ADODB Library http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q291199 Q263498 BUG: Run-Time Error 5 Using Add Method of QueryTables Collection http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q263498 Q244761 XL2000: How to Use ADO to Return Data to a ListBox or ComboBox http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q244761 Q228633 OFF2000: "Catastrophic Failure" Error Running Samples.xls Macro http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q228633 Q225059 XL2000: "Invalid Use of New Keyword" Error Using ADODB Library http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q225059 Hope this help you , With regards, Suresh [Microsoft MVP | MCAD.NET(CM) | MCSD.NET(CM) ] ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
