Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    14

    Unanswered: Export Multiple Tables

    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?

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    It can be done using Visual Basic. There is no wizard that I know of to help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •