I did a test to see if the code would run/create the multi-sheet excel file. Yes it did.....but I first had to save my "access query" as a txt file. Is this the proper way to do this and/or only way to import to excel in multiple sheets?
Is there not a code that can be run from Access to create an excel spreadsheet? Either way looks to require several steps to process all the data I have. The data is line item transactions that occurred over several years and many customers. My goal is to get a sales total for each customer by year. Any further comments on the most efficient way to accomplish this ?