link access to excel

[rainbows]

I have a excel spreadsheet that had about 8 sheets within it , i know you can link excel to access and then change the data in excel which will update the data in access.
is it possible to have the same thing but in reverse . ie update the data in access and it changes only sheet "one" in excel

thank steve

 

[The_Doc_Man]

It actually depends on which version of Office you are using. Older versions of Excel did not allow Access to update a worksheet, but some newer versions can do it. IF you can successfully map a worksheet to be read/write from Access, then it is possible via linking. It is ALWAYS possible to open the Excel workbook as an Excel Application object and navigate to any row, column, and worksheet (page) to make changes using VBA code.

 

[ebs17]

Power Query has been around since Excel 2010, providing rich and easy-to-use methods. One of the first ways is to load content from external sources. An Access table or query is an easy exercise.

 

[CJ_London]

Also depends on the nature of the changes - manual changes ok, append/update query maybe not. Delete manually or via a query no