Ok, if I can make this work, this takes nearly 100 import runs from excel into Access and turns it into a button click process....fingers crossed.
Background: I have an excel sheet that Alteryx grabs, does a little transformation work, and then saves to Excel, parsed out into tabs based on a field in the data. I.e., the original excel contains a big list of records with a field called 'analyst' and the output is an Excel where each analyst gets there own tab. Then, I load each tab into the final Access Db, appending to each table by each Analyst tab through a Save Import. It works, but is zero fun and, of course, it's a matter of time before that process bites me.
So, I want to use the same parsing (by Analyst) to append to the almost 100 Analyst tables in the Access database and cut out the middle man.
I researched and have, what I think, is close to a solution, but get the following error:
Error: Output Data (9): Error opening query: Microsoft Access 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
Any help is appreciated.
Many thanks!
Jim
