Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 data import wizard does not support line ends in fields ChrisLime Excel Discussion (Misc queries) 0 February 25th 09 12:07 PM
Excel 2003 ODBC driver without support for XML files? Boris[_8_] Excel Programming 0 August 20th 07 05:27 PM
Support for Multiple Monitors Excel 2003 Dickie Excel Discussion (Misc queries) 2 June 8th 07 12:46 PM
xml support in Excel 2003 Hey steve Excel Discussion (Misc queries) 2 March 2nd 07 11:59 PM
does excel 2003 support more than 65k rows? Landman Excel Discussion (Misc queries) 4 October 10th 06 05:57 PM


All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"