Excel Macro

[Tom Nowak]

I am writing code behind an Access 2002 database, and I
want to be able to click a button on an Access form, and
have an Excel 2002 macro run, then import the data from
Excel 2002 to my Access 2002 database. How do I do this?

 

[Jake]

Try these articles

http://www.mvps.org/access/modules/mdl0006.ht
http://www.mvps.org/access/modules/mdl0007.ht
http://www.mvps.org/access/general/gen0008.ht

HTH
Jak

----- Tom Nowak wrote: ----

I am writing code behind an Access 2002 database, and I
want to be able to click a button on an Access form, and
have an Excel 2002 macro run, then import the data from
Excel 2002 to my Access 2002 database. How do I do this