what is the difference between OLE DB and ODBC data sources?

by

I was reading a MS Excel help article about pivotcache and wonder what they mean by OLE DB and ODBC sources

…You should use the CommandText
property instead of the SQL property,
which now exists primarily for
compatibility with earlier versions of
Microsoft Excel. If you use both
properties, the CommandText property’s
value takes precedence.

For OLE DB sources, the CommandType
property describes the value of the
CommandText property.

For ODBC sources, the CommandText
property functions exactly like the
SQL property, and setting the property
causes the data to be refreshed…

I really appreciate your short answers.

11 Answers
11

Leave a Comment