I am working with an program that is drawing information from multiple tables and feeding it into a temp-table, which is then put into an excel document record by record.
My only issue is that the last few records (it seems to depend on the size of the excel document) seem to be getting cut short or missing entirely. Now I've exported the temp-table into a file so that I can verify that all of it's contents are there and they are. It just seems to be stopping early.
Does this have anything to do with Office '07? I am saving in a .xls format.
Thanks in advance!
My only issue is that the last few records (it seems to depend on the size of the excel document) seem to be getting cut short or missing entirely. Now I've exported the temp-table into a file so that I can verify that all of it's contents are there and they are. It just seems to be stopping early.
Does this have anything to do with Office '07? I am saving in a .xls format.
Thanks in advance!