[Urgent] C++ ODBC/ADO -> Excel 2007 file

[ayu]

I need to find how to connect to a Excel 2007 file using C++ and extract data. I have found several forums where they TALK about it, but never any information about what libraries to use, where to find them, or how to use them with the Excel drivers (in case of ODBC).

Any help in finding this information will be very much appreciated (I'm on a deadline and the information I had before about this turned out to be wrong, so I need to search for a new method).

PS: If anyone decides to help, then please don't just google it and post the first link you see. If you don't know what your are looking at/for then don't bother, because I don't have much time on my hands.

Thanks in advance!

[Gogeta70]

I don't know if this will help, but maybe it will ^_^

http://www.libxl.com/

I haven't coded in C++ in a looong time XD

[ayu]

I don't know if this will help, but maybe it will ^_^

http://www.libxl.com/

I haven't coded in C++ in a looong time XD

Yeah but it's really expensive, and the trial is useless

[Gogeta70]

I remember that in PHP, you can modify excel 2007 documents - here is how they did it:

http://openxmldeveloper.org/articles/De ... ntent.aspx

Maybe that will help ^_^

[ayu]

Thanks for the suggestions Gog : - )

I found a professor at the uni who knew of a good solution.

First I make a function that uses Excels own functions to export it to a text file with tab separated data. Then I use SQL to import it to the database : )

[Gogeta70]

Lol, i tried ^_^

At least you got it all figured out.