import from excel to access with macro?

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
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.
 
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.
 
Back
Top