does VBA e.g. excel XP/2000/97 supports ado.net assuming you have the
framework installed?
Not directly. Essentially you would need to create a .NET class wrapper that exposes the ADO.NET
code and then register it with COM.
ms-help://MS.VSCC/MS.MSDNVS/cpguide/html/cpconregisteringassemblieswithcom.htm
Microsoft MVP (Visual Basic)