This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My work are very sensitive around what information we share so I can't include a workflow. Its a bit frustrating, I know.
When I "Append to Existing Sheet" I get the following error
Output Data (22) Error opening query: Microsoft JET Database Engine: '' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.\3125 = -537199594
I can get the data in using "Delete Data and Append' or "Overwrite Sheet (Drop)" but not sure how to best deal with extra lines if needed?
Also, my data get converted to strings when I drop the header so had another discussion on using SQL to remove the header after pasting in
Here is (a highly redacted) picture of my output - The red square is the named range
And here is a screenshot of my workflow. Very simple just trying to drop the data into Excel - Range = "Journal_Detail"