I'll have a look, tomorrow. The copy seems to work
as you expected. The copy sheet is filled with the
data from the original sheet. But it stops at row
183.

There are 312 rows in the original sheet. So some-
thing is stalling the copy process, part-way through.

Is this what you needed to see?
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\PerryE\My Documents\Spreadsheet files\Address List VBA1.xls;Extended Properties="Excel 8.0;HDR=YES";
INSERT INTO TargetRange SELECT * FROM SourceRange