I'm working with a teacher grading program that allows for the importation of student records so teachers avoid having to manually type each name, ID, course ID, etc. I have a large text file containing 16,000 student course records. I'd like to save teachers time by creating text files for each of their courses. Currently, I run a make table query that prompts me to enter a course ID for criteria. Then I export the new table to a text file with the file name corresponding to the course number.
Is there a way to export multiple tables simultaneously to text files, giving each table the file name corresponding to the table name in Access?