Can Excel 2003 support ADO.NET 2.0?
I was used to use OLEDB connect to SQL Server from Excel 2003. I want
to know is it possible to have Excel 2003 support ADO.NET 2.0? If possible, what kind of library should I install? where can I get it? Thanks |
Can Excel 2003 support ADO.NET 2.0?
I don't believe you can use ADO.NET out of VBA. You'd have to write an
managed add-in for Excel using VS2005/VB.NET/VSTO. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "AY Xu" wrote in message ups.com... I was used to use OLEDB connect to SQL Server from Excel 2003. I want to know is it possible to have Excel 2003 support ADO.NET 2.0? If possible, what kind of library should I install? where can I get it? Thanks |
All times are GMT +1. The time now is 10:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com