DSXchange

Hi,

I am trying to write in to multiple worksheets in an excel file and have an error such as the following :

The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.


The design is that 5 output links coming out of a DB2 stage are writing in to the same excel worksheet but different spread sheets (using ODBC).

When there is one output link I have no error. Anything more than that I am getting the error.

Any suggestions to get it working would be appreciated...Thank You.

Try to fill one sheet after the other....

You can do it by saving your Excel workbook in .csv format and give each sheet a different file name.

i think it should create new .csv file for each of file creation link or transformation.

It seems the only option I have at the moment is to write in to a spread sheet at a time.......

sachin1 wrote:i think it should create new .csv file for each of file creation link or transformation.

Why do you say "at the moment"? Do you have some inkling that Microsoft is going to change the way it works?

That I am not too sure but from your answer I guess it's not possible to do what I want...Thanks !

ray.wurlod wrote:Why do you say "at the moment"? Do you have some inkling that Microsoft is going to change the way it works?

Cosec,

Are you able to write into spread sheet..if yes please let me know which update action did you use? Thanks..