If you have a table that contains the fields you want to append data
to(subset table). You design a query using your master table as the data
source for the query. Add (Double-click or select and drag) "only" the
fields you want to update in your subset table, to the design grid. On the
main menu select the Query/Append Query option. You'll be prompted to
select the table you want to append the data to. Select your subset data
table. If the field names of both table's are the same the names will
probably be automatically placed in the Append To row in the design grid.
If not select the field you want to append to. Run the query. Hope I
understood what you are trying to accomplish.
--
Reggie
www.smittysinet.com
----------
"Danny" <da********@hotmail.com> wrote in message
news:9D**********************@news4.srv.hcvlny.cv. net...
I want to extract a subset of fields from one table into another
the master table has many fields
the subset has about half, but still many.
Is there a way I can just append the master into the subsets structure and
this way only the existing fields in the destination will be filled?
That would be great, but it seems that the append query wants you to
specify the fields.
is there another way around this?
I want to do it in code and it seems the sql string will be too long.
I remember you could do this in dbase I think.
Thanks in advance