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

SUSAN


OOPS - read your post wrong - I have input files from the counties that
go into ONE table. I use the county id code to identify where it came
from as I insert the the records into the table.

You really should only have 1 table if all the data is the same at the
end point.  I can understand having several input files since ours come
in at different times.

Patti
-----------------------------------------------------------------

Susan
Are you using VB or are you using the import wizard.  Do you have the
code for getting a table? I do something similar but with text files. 

What are the name of the files? 

Patti  

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Klos, Susan
> Sent: Monday, April 19, 2004 03:40 PM
> 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
> 
> 

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com