Originally posted by: SystemAdmin

Hello,
Is there possibility to get from MS Excel some information when button is clicked?
I'm sorry if that is easy, but I am beginner :)
Thanks
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Using Excel is similar to writing to a db, but it is much easier to do if you can save the file as tab or pipe delimited. Then it's just a text file and is easy to parse. You can email me directly if need help with a specific task.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

experience is similar. Easier to use csv formats.

You need to setup an Excel ODBC for the file. You can then use DBID to build your trees, queries, etc...
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Using Excel is similar to writing to a db, but it is much easier to do if you can save the file as tab or pipe delimited. Then it's just a text file and is easy to parse. You can email me directly if need help with a specific task.[/quote:1c29cd7a3b]

Is it impossible without saving my excel data to a file? I am wondering if I can take some data directly from an open Excel document. Not from a physical file.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

you can use ddequery....
There are a example on how do this that comes with the install of Design Studio.
It requires the dokument to be open and a running excel on the machine.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange