I am trying to populate an excel workbook using a data flow and it no longer works. I have a command button in cell a1, so the column headings need to start in row 3 and the data in row 4. also the column headings need to be red background. the data is
ending up in the right row but no all the rows are also red. everything was working fine, now it is broken and cant figure out why. first i DROP TABLE, to clear the contents of the worksheet, this now only clears the column headings, the i CREATE TABLE, to
put back the column headings, this works. Then using the data flow I populate the spreadsheet, it end up in row 3, which is right, but honetly i dnot know why. the problem is all the data rows are red. can anyone please help me with this. thanks.
View Complete Post