Updating an Existing Excel Worksheet w/ Access

[rss01]

Does anybody know how I take my access query results and have them automatically paste into a existing workbook on an existing worksheet?

Thanks

 

[Rick39]

Take a look at

http://www.zmey.1977.ru/Access_To_Excel.htm

 

[ETID]

You would not need to export the data to excel, (too many steps)...

Create a live link to the table or query from within excel,

From excel click Data>Get External Data>New Database Query>....the choose msaccess databases* from the list...follow the wizard from there (to select your mdb, table or query)
then return your data to excel. ...if your query has prompt paramters,...move them to the msquery interface within excel.

You can opt to use the wizard or MsQuery (a less impressive gui type interface, similar to access)at this point...
after your comfy with this...I would recommend the MsQuery option.


when data is returned,...you can right click in the data and select properties to refresh on open...auto fill formulas etc.

this is now a live link, any time the workbook is opened. your current / up to date access data comes in (if you set the refresh on open option)

 

[rss01]

Sorry, I should of been clearer in my post. Once this updates the excel sheet it will be emailed to the field. They do not have access to the server the data is on.

I know how to do everything except for the automated updating on a existing excel sheet.

 

[ETID]

the data can still reside on the sheet...

it just won't update remotely....


an alternate... export your data as an excel sheet to an ftp server,..then link the remote sheets via an internet connection. to the ftp domain name.