Can't append data to existing excel as table

Hi Team,

I have successfully used the Output Data tool to append to append data to a excel spreadsheet using a small data set. However when I tried to do this for a larger data set and to a excel file with many more tabs which have validation rules built in it does not work. If I try appending to an existing sheet nothing happens and if I try on a new sheet the data will save to one cell but not as a table.

I am not sure if I need to change anything on the excel file itself in case that is the issue.

Has anyone come across this before or can anyone help?

Many Thanks

Output

Accepted answers

All comments

TrevorS

Hello @Bushra_Akhtar
Thank you for posting to the Community!
Are you receiving any specific error messages from the workflow when the append fails? If so, please share the text for the error message.
If possible, please also share a copy of your workflow and some sample data for the Community to use to troubleshoot.

A few things to check right off the bat:
Is the Excel document shared? If yes, make sure no one is using it when you run the workflow otherwise it will fail.
Does your dataset match the layout of the table you are trying to append to?

I have attached some additional posts for you that have some useful information regarding appending data.

Tool Mastery- Output Data

Interactive Lesson- Writing Data

Can't append data to existing excel sheet

Thanks!
TrevorS

Bushra_Akhtar

Hi Trevor,

Thanks for responding. I have attached the workflow. It seems pretty easy to do if I don't use the 'Table Tool' but once I use this I can't append to an existing excel table range. I get the below error message:

Error: Output Data (29): Incoming field named "Table" cannot be appended. All incoming fields must match (or be mapped to) a destination field name.

I have noticed I lose the ability to 'map' my fields when I use the table tool.

Many Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703