Access 2000 – Field Data

I want to read a record and append that record to another table. However, I want the destination table name to be the data found in a field within the origional record. Is there any way I can use the data in a field as the destination table name?