Write to Excel

[terry_stjean]

I'm using Data Manager 10.2. I know how to reade from an Excel file but how do I write to an Excel file?
I came across an IBM document which said to create an ODBC connection to the Excel file.
But how do I specify to use the ODBC connection on the Fact Delivery tab?

[terry_stjean]

Okay, I figured it out.
The only issue I have now is that you cannot delete data from the Excel file. It looks like you can only append.
Any suggestions?

[MFGF]

You could perhaps call a system() function in a variable initialisation at the start of the build which removes the .xls file when the build starts? Or do you want to selectively delete rows?

MF

[terry_stjean]

Actually what I ended up doing was to created a blank Excel file called template.xls.
Then at the start of the routine , I copy the template.xls to the folder the ODBC points to and then populate that file.