[AccessD] RE: AccessD Digest, Vol 14, Issue 31

Susan,

I have not seen your prior conversation, and have no knowledge of other
details on this outside of this post, but if this solution was presented to
me I would be very inclined to rethink it.

Although you have multiple input files, you only have a single file
structure to deal with.  I would recommend pulling all files into a single
table initially, with an extra field in the table indicating the source or
district.

This leaves you with one import routine (file name and path as a paramater)
and one data structure to deal with.

Ask yourself, what happens when they restructure or add districts in the
future?  Or when you have to alter the data structure for any reason?  Your
structure quickly becomes a monster requiring exponentially more support.

If you have to perform complex data cleansing on the base data before it is
appended to the single master table, you can utilize a single staging table
for your file load, and a cleansing routine for your append.

Mark

> -----Original Message-----
> From: Klos, Susan [mailto:Susan.Klos at fldoe.org]
> Sent: Monday, April 19, 2004 11:40 AM
> To: 'accessd at databaseadvisors.com'
> Subject: [AccessD] RE: AccessD Digest, Vol 14, Issue 31
> 
> 
> 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
> 
> 

***********************************************************************************
19/4/2004
This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you. ACS