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