import from excel to access with macro?
 

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.

import from excel to access with macro?
 

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.

import from excel to access with macro?
 

thanx!