[AccessD] Re: Changing the table in a query so I can loopthrough thequery

Susan,

 From what I read below, you can distinguish which excel file is from which 
district.  Why not just append them to the single table and use the 
distinguishing factor to pass in the value of the "district" as part of the 
INSERT SQL statement?

Robert

At 03:42 PM 4/19/2004 -0500, you wrote:
>Date: Mon, 19 Apr 2004 15:39:49 -0400
>From: "Klos, Susan" <Susan.Klos at fldoe.org>
>Subject: [AccessD] RE: AccessD Digest, Vol 14, Issue 31
>To: "'accessd at databaseadvisors.com'" <accessd at databaseadvisors.com>
>Message-ID:
>         <01B619CB8F6C8C478EDAC39191AEC51E0410CB at DOESEFPEML02.EUS.FLDOE.INT>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>Robert, I need 71 identical tables because I am getting the same structure
>Excel file from 71 districts.  The structure is the same but the data is
>different.  I want to be able to loop through the tables and append their
>records to one table.
>
>Susan Klos
>Senior Database Analyst
>Evaluation and Reporting
>Florida Department of Education