>If you're planning to append the data as new records in a table, then either INSERT or APPEND will do. Use the RecordSource of the grid, and SCAN it (or use a do while loop if it's faster) adding the data one record at a time if any field needs to be changed. If it's just a matter of adding all data in cursor/view/table A to table B, use APPEND FROM.
>

APPEND FROM is what I want to do. It is a view. I can't seem to get the syntax correct.

I have tried:
SELECT EquipMeter
APPEND FROM ThisForm.Grid1.RecordSource

and
SELECT EquipMeter
APPEND FROM ThisForm.Grid1.RecordSource()

Many thanks for your help.