I get a csv file from my company's bank that contains daily activity for 50+ bank accounts. I import this file into MS Access. I am trying to figure out if there is a way to filter this table based on account nbr and export that filtered data to an CSV file that I can share with others in my company.
I know that I can create a query and then export the results to a CSV file, but I'm not too crazy about having all those queries in my database. I was wondering if there was a way to use the RunSQL command in VBA to create a filtered set of data and then export the results to a CSV.