inserting multiple rows at once

[Alifrog]

I need to insert 800 rows in a report at one time so that I can copy from an
Exel file and paste into the report. How do you insert multiple rows without
having to type something in each row before you can enter another row? Or is
there a way to paste 800 rows when only 20 are created already in the report?
When I've tried this, only the first 20 of my 800 rows are pasted.

 

[John]

Hi
Update the query which is your report source. Use an Append Query to update
the rows imported from the xls file.

Regards

John