Read & Write Excel-Files (*.xlsx)

[beckj]

I'm trying to to get a ADO connection to an Excel-File for read and write. With the example in the online help not even the connection to Access works.

Who can help me?

I'm using a 64 bit Windows 7 with 64 bit WinCC OA 3.11 SP1. Microsoft Office 2010 is 32 bit version.
I have added CtrlDLL = "CtrlADO" in the [ctrl] and [ui] sections.

I added the code from the example to the click event of a push button.
All I get is the following debug msg generated with dbGetError. Code means "Unspecified error"
[dbConnection "73D4DC8"][1][-2147467259][0]["[Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben"]["IM002"]

Thanks

[Gertjan van Schijndel]

I do not think you can use the 32 bit version of microsoft office with 64 bit WinCC OA.
Did you also try it with 32 bit WinCC OA?

[beckj]

I have to use 64 Bit WinCC OA. Microsoft itself recommends to use 32 Bit Office.
If that doesn't work together I have a serious problem!
And if nobody ever has read and/or written Excel files, I'll never get any advice.
So I'll have to go with CSV-files, which is ways too weak compared with Excel.

[vogler]

Hi,
try to configure your odbc-connection with C:/Windows/SysWOW64/odbcad32.exe ...
brgds.
Andy

[vogler]

or maybe you can try to install a 64bit odbc driver
http://www.microsoft.com/en-us/download ... x?id=13255