Interfacing with Excel and Access

[EverGreen1231]

Does anyone have experience with interfacing with Excel and Access in a C++ program. I need to get some data from an Access data base automatically; if I were to do it by hand it would take far too long. I would like to take this information and insert it into an excel spreadsheet.

Any help would be much appreciated.

[vlkon]

Is c++ a "must-to-have"? I would have an advice to use Excel default programming interface with Visual Basic. Since both programs are part of the same Office group I guess that there will be some easy interface to do this.

Try your luck
https://www.google.cz/?gws_rd=ssl#q=excel%20vba%20access

[mutexe]

You might want to look into COM. http://stackoverflow.com/questions/2938435/comc-programming-tutorials