Inserting in to Multiple worksheets

cosec · Post by **cosec** » Tue Jan 29, 2008 3:12 am

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.

WoMaWil · Post by **WoMaWil** » Tue Jan 29, 2008 4:21 am

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

MOHAMMAD.ISSAQ · Post by **MOHAMMAD.ISSAQ** » Tue Jan 29, 2008 6:26 am

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

sachin1 · Post by **sachin1** » Tue Jan 29, 2008 10:56 am

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

cosec · Post by **cosec** » Tue Jan 29, 2008 7:22 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 29, 2008 9:18 pm

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

cosec · Post by **cosec** » Tue Jan 29, 2008 9:22 pm

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?

edward_m · Post by **edward_m** » Mon Apr 28, 2008 2:08 pm

Cosec,

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