I need to retreive data from excel files into data structure in c++ using vs2005.
can someone please help me at least to define the connection string?

thank's in advance

try reading some of these gogle links

It would be a lot easier if you first export the excell file into a *.csv file because csv file is a plain text file that can easily be manipulated using C, C++, or any other computer language.