Insert into table (field1, field2, ... fieldn) Select data1, data2, ... datan
Be aware that the data values must be appropriately deleniated. A string must have quotes on either end (and not anywhere in the string). A date must have the hash (#) on either end.
Tip: Use the query builder to create an Append query (same as Insert) then switch to SQL view to get the string.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group