Update Excel with Access data

[Tim]

I'm trying to figure out the best way to frequently update
an Excel Worksheet with data from an Access Query. I can
use the transferspreadsheet method but the problem is that
if the spreadsheet is open, then the function fails. This
is a situation where someone needs to be able to update
the data in the Excel spreadsheet with the click of a
button in Access but there is a good possibility that
someone else will have that spreadsheet open at the time.
Can anyone offer any suggestions?
Thanks

 

[John Nurick]

Hi Tim,

I don't think there's a safe and reliable way of doing what you want
given Excel's very limited multi-user capability. Much better IMHO to
set up the spreadsheet so it fetches the latest data for itself whenever
as often as needed.

 

[onedaywhen]

I'm trying to figure out the best way to frequently update
an Excel Worksheet with data but there is a good possibility that
someone else will have that spreadsheet open at the time.

What do you want to happen in this scenario? You have some choices
including:

- Immediately force the Excel workbook to close, with or without
saving it in its current state.

- Wait for the user to save the workbook then force the workbook to
close.

- Wait for the workbook to be closed.

What do *you* want to do?

--