Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 data import wizard does not support line ends in fields | Excel Discussion (Misc queries) | |||
Excel 2003 ODBC driver without support for XML files? | Excel Programming | |||
Support for Multiple Monitors Excel 2003 | Excel Discussion (Misc queries) | |||
xml support in Excel 2003 | Excel Discussion (Misc queries) | |||
does excel 2003 support more than 65k rows? | Excel Discussion (Misc queries) |