You need to use ADODB Recordsets to do that via a macro. It is not distinctly
difficult but it does require a bit of know how.
--
HTH...

Jim Thomlinson


"J.W. Aldridge" wrote:

Have existing access table.
Imported data from the following source.
C:\Documents and Settings\jw\Desktop\[error_report_play.xls]Sheet3

Need macro in access that will return to the same data location and
copy all of the data to the next available row in the table.