Updating Excelsheet

[samusa]

Hi,
Is there a way out to link MS Access query results to excelsheet so that whenever query is executed it will automatically update spreadsheet. Appreciate it.

Sam

 

[JerryKlmns]

If the query opens with VBA then before opening use DoCmd.Transfersheet method to export. If the query opens from the database window, you 'll have to get the result into excel from access and not the other way

 

[PWise]

Try this Jet Query

UPDATE [WorkSheetname$] IN '' [Excel 5.0;HDR=yes;IMEX=0;DATABASE=\\filepath\filename.xls;TABLE=WorkSheetname$] SET [WorkSheetname$].Fieldname1 = "Value"
WHERE ((([WorkSheetname$].Fieldname2)="xxxxxx"));