I have a DTS that exports a view to an excel file, is it possible to append data to an excel file, it seems if it sees that the sheet is available it creates a new sheet,
I have a logo in my excel file and I want to append the rows below it.
If you're looking to populate a Worksheet with data at a specific location I think you will probably need to use Excel automation instead of a batch or data access method. See the following for more info:
How to transfer data to an Excel workbook by using Visual Basic .NET
No comments:
Post a Comment