Updating excel worksheet from access query

; microsoft.support.content = (function(){ return { "click Tale Configuration": , "Internal Content Config": , "Mwf Configuration": , "Rps Sign In Info": , "Site Content Config": { "Link Farm Enabled": true, "One Site Service Uri": "https://uhf.microsoft.com//shell/xml/?

I used to update linked spreadsheets from a query in access with no problems in an earlier version of access (97). Example-I link to tab "policies" in an excel file that contains policy counts by zip code. I can import and do the update and then export, but what a lot of extra work--can I update the spreadsheet directly somehow? Conceivably, it might also be possible to come up with an elegant VBA solution to update an existing Excel file from Access.

Make sure you do both those things when writing your own ADO scripts for accessing data in a spreadsheet.

Is there something that changed in the linking process between access 97 and access 2003? Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder. However, to update the Excel file in the end, I think you would need to export from Access at that point (and import that into Excel).

But that may not be feasible or possible (unless you have an old copy available to you). Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder.

Welcome to Office Space, the column that offers tips and tricks for scripting Microsoft® Office applications.

I then need to update the Access data with data that is passed back.

I distribute this to some people and ask them to update fields.

Leave a Reply