Forum Discussion
Append Queries as New
I receive an Excel workbook every month with sales data from a customer. After four months of reports, the customer changed the formatting of the workbook. My report includes the last 12 months of da...
spaces in column names (leading or trailing)?
upper or lower case differences?
HotChilli
Community Champion
Community Championspaces in column names (leading or trailing)?
upper or lower case differences?
Thank you, HoChilli! It was a caps issues. Bill-To State - Bill-to State. Something I missed when I recreated the the Append query for the nth time after correcting bigger errors.