I think you will need to create 35 append queries (or one within a loop in
VBA that uses a variable). Each query to have criteria that looks for the
district within the master name field.

Criteria example (replace District with actual name):

Like(*District*)

Bonnie
http://ww.dataplus-svc.com

Bobharis wrote:
I HAVE A DATABASE FOR 35 DISTRICTS. THERE ARE MASTERS WITH SPECIFIC NAMES
WITH THE NAMES OF THE DISTRICTS AS PART OF THE NAME OF THE MASTERS. I WANT
TO IMPORT OR COPY THE TABLES TO RESPECTIVE DATABASES THROUGH EITHER MACROS OR
CODE. CAN ANY BODY HELP ME OUT.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200912/1