Appending data to an Excel Table

I have converted data from text files into fields which are identical to an existing data warehouse table used for PowerPivot.

What I would like to do is to append an exiting table within Excel. If I were to paste the new data into cell A2051 (assuming that the last row in the existing table is A2050) Excel would would automatically increase the range of the table to include the new data. Pasting values only would copy existing formatting.

Within Advanced ETL Processor you are able to define the worksheet and the existing choices within the Writer for Excel are:

Create a new file
Add data into an existing file
Clear area first
Insert data starting from
The Top
Cell ...

The number of rows in the target file is dynamic and is defined by the table's range. It would also be nice to append data to an existing table.

Excellent idea, which will benefit other users as well.
We will do our best to add it to the next release.

Peter

Hello

Can you try latest version please

You should use the settings provide on the picture attached.

Mike

Mike:

Thanks so much for jumping on this enhancement so quickly!

I tried the lastest version and there are two issues:

1. The data was added starting at the last row, however, the data wasn't appended to the existing table (increasing the size of the existing named table). The table properties were actually removed from the Name Manager within Excel.

2. While I was able to select the last row option and it worked once you save the Writer Properties and re-open it the selection reverts to "The Top". I ran the tranformation again and the data was again added to the bottom and not at "The Top".

I thought I attached a screenshot of the Writer Properties dialog box, but it's not apparent from the reply input screen.

1. The data was added starting at the last row, however, the data wasn't appended to the existing table (increasing the size of the existing named table). The table properties were actually removed from the Name Manager within Excel.

I do not think there is anything we can do with that at the moment

2. While I was able to select the last row option and it worked once you save the Writer Properties and re-open it the selection reverts to "The Top". I ran the tranformation again and the data was again added to the bottom and not at "The Top".

I do not really understand that one.

Are saying that you selected "Last Row", saved the script, closed it, opened it again and it returned back to "The Top" option.

Mike

Mike:

That is true. It went back to "The Top" option, yet when I ran the transformation again, data was placed at the bottom.