Click to See Complete Forum and Search --> : accessing Excel data from a Access macro


JillB
November 30th, 2007, 04:03 PM
I can transfer data from Excel to an Access database using a macro residing in the open Excel workbook OK. ( Google ADOFromExceltoAccess).

does anyone know of any macros which reside in Access database, and import specified Excel cell data into fields in Access?

All suggestions and pointers gratefully received

kind regards,
Jill