Can Excel 2003 support ADO.NET 2.0?

  • Thread starter Thread starter AY Xu
  • Start date Start date
A

AY Xu

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to extend Excel with custom data provider? 2
importing alphanumeric columns from excel into SQL-Server or MS-Ac 2
vba & SOAP - which soap library & version? 3
Excel How to enable engineering functions in MS Excel 2000? 3
Subselect, TableAdapter and MS-Access 1
Online Help on VBIDE 3
dbcommand verssus sqlcommand 1
auto translate=false in ADO.NET 2.0 0

Back
Top