import from excel to access with macro?

J

J.W. Aldridge

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.
 
J

Jim Thomlinson

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.
 
Top