As far as I understand, OLEDB is a wrapper based on ODBC, and it is more flexible and more convenient in use. For Excel there are also additions regarding OLEDB, and with each new version.
You may find useful the connectionstring references at
http://www.connectionstrings.com/default.aspx>I guess what I am trying to figure out is which route should I go in anticipation of which technology Microsoft will keep, and which it will soon abandon.
>
>My hunch is that MS prefers OLE DB over ODBC, and I am concerned about JET's future.
>
>Any thoughts on that? I wonder if anyone else could through in thoughts on this as well.
>
>Jim