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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>