MS Excel problem!

Hi all experts,

I have created a program to put more control on data being used my organisation.

What I want now is that:

User download data from access and update a column in excel. I want the records to be updated in access as well based on unique journal number through DAO. Can anyone give the code to find and update a record in access through excel.


I will be greatful if anyone can help me with above macro.
Please e-mail me at email address removed - Moderator

Regards,
Neeraj

Welcome to the Forum,

Which way round are you looking to achieve this. IE from Excel get the data out of Access or from Access send to Excel?

What you can do is set up a docmd.transferspreadsheet from Access, do what you want in Excel, then transfer it back in Access perhaps to a temp table then use an update query to update the changed records.

To help you we would request you also let us know which version of MS Office you are using, if using VBA then it will help stepping through the instructions.

Thanks Trevor for this great help. Though I am new to this I will try the option suggested..

Thanks once again