Can Excel 2003 support ADO.NET 2.0?

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
 
C

Chip Pearson

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)
 

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
ADO.Net 2.0 version of CopyFromRecordset 0
ADO.NET truncates excel data 0
Default local file location - folder redirection slowness 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
importing alphanumeric columns from excel into SQL-Server or MS-Ac 2

Top