Moving data from a Database to Spreadsheet & Activating a ma

[COJMORE]

Hi,

I need to transfer some details from my database to a spreadsheet and then transfers the details back to the appropriate tables in the databse! Can anyone help me here?

Also, I need to somehow activate a macro in the MS Excel spreadsheet from Access? Any ideas?

Any help would be greatly appreciated,

Thanks again,

COJMORE

 

[John in PA]

I'm not exactly sure what you're trying to do but you can create a query in excel to retrieve the information in access. All you have to do is click Data, Import External Data, New Data Base Query. You can select the fields you need, modify them and they will be updated in Access. Regarding the macro, create a procedure in Access using SendKeys and give the macro in Excel a shortcut key then code the sendkeys to run the macro.