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.
I am using a formatted Excel template with specific named ranges. When I output data from an Access table into the Excel named range, the header from the Access table is pasted into the Excel named range. Is there a solution to skip the header record when pasting into the Excel named range?
If that field is a part of your final output, you can use a formula tool before the dynamic rename to create a duplicate of this field, and deselect the duplicated field in the dynamic rename tool. Then you can use the new duplicate field in the Output Data options to change the sheet name, and uncheck the "Include in file" box.
Again, there might be better options so I don't want to say this is the be-all end-all, but this should work for your need.