I am trying to create a button or a simple form for a few research assistants to quickly import survey data (.csv) into an Access DB.
I’ve figured out how to import the csv file as far as a table, but I need to then copy the data into multiple (like…25) tables throughout the database.
So far all I can think of would be to create 25 separate append queries for each destination table and then set up a macro to run all of them onclick. Is that even possible?
I’m completely in over my head here, any tips?
Thanks a lot