Search:

How To Use ADO with Excel Data from Visual Basic or VBA

Try this: Office Space: Tips and Tricks for Scripting Microsoft Office Applications

What you to focus on is ADO connection string and SQL query.

In fact, you hit a very specific topic of importing COM server in your C++ program. Very little it has to do with C++ real complexities, but requires quite a good knowledge of COM technology.

I...

You have missed to define a pRec smartpointer (seems should be _RecordsetPtr, see in generated .thi). The same to TESTHR macro. It looks like you copied the snipped from somewhere, and the copy...