connecting xMII to excel

[Former Member]

Hello all,

I understand that xMII can connect and read data from excel.

1) Wanted to know more details about this. Is there a document on how to accomplish this?

2) Also, is there a way to access the value of a specific cell residing in a particular tab(sheet) of an excel document?

Appreciate your answers. Thanks.

[Former Member]

1) You'll need the OLEDB UDS to do this.

2) In order to access cells in an Excel spreadsheet, you create a "named range" along with column heading cells that make the range appear as a database table to the OLEDB driver