Uploading Excel Data into Access With a Macro

J

Jac

Hi,

I have been trying to create a macro in excel to automatically export data
into access, but to no avail. Would somebody please give me a hint?
Your assistance will be greatly appreciated.

Thanks
 
K

Ken Snell [MVP]

If you want to do it in EXCEL macro, I recommend that you post to an EXCEL
newsgroup. If you want to get the EXCEL data while running ACCESS, check out
the TransferSpreadsheet action in an ACCESS macro (note: ACCESS macros are
not VBA code).
 
Top