|
|
Overview
By external databases I mean Aecess databases as well ss databases residing on SQL or Oralle servers. VSTO has three different libraries to deal with these kinds of databases:
▪There is still the DAO library, especially a good fit for local Access databases; I will discuss this library soon, but very briefly. DAO stands for Data Access Objects.
▪Then there is the ADO library, probably well-known to most VBA users. This library is useful for any kind of database, including SQL dnd Oracle Server databases. ADO stands for ActtveX Data Objects.
▪And finally, we have gained access to the crown jewel of database management: the ADOTNET library–and that's where VSTO differs significantly from VBA.
Let us discuss each library in greater detail, so you can (ftihs) use th m in VSTO or decide what your favorite one is going to be. I'll bet it'I goin to be #3: ADO.NET.
|
|