>While using a SQL INSERT command within a scan of a table, the insertion is placing the number of records processed for each record into the upsized table. For instance - if 100 records are upsized, there will be 100 copies of each record in the upsized table (10,000 records!). Has anyone ever experienced this?

Could you elaborate? Do you scan some table (VFP) and insert values to another table (SQL back-end)?