Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Update Linked data in Excel from Access
Name: Jen2010 Date: July 8, 2009 at 09:56:00 Pacific OS: Windows XP Subcategory: Microsoft Office
Comment:
I have imported data into Excel from an Acess query. My problem is that it does not update unless I delete the query and re-import. I think it's because it's embedded and not "linked." I need it to update everytime the spreadsheet is opened. Thanks.
Name: orange Date: July 11, 2009 at 07:43:43 Pacific
Reply:
If you import, you'll get a copy of the current data. It will be a "point in time" copy.
You could set up to do a delete and reimport each time. Or you could link the table, and do a delete and relink each time.
0
Response Number 2
Name: Jen2010 Date: July 13, 2009 at 07:15:09 Pacific
Reply:
I have set up a macro that allows them to select my command button and refreshes the data. I was expecting that when the spreasheet was opened that Excel would ask the user if they wanted to update or not, like other links. Not quite sure why it doesn't do that?? but I've accomplished the bare minimum of what I need. Thanks for your help, I really appreciate it!
Summary: My question relates to linking workbooks and updating the information in them. I have a source workbook, several destination workbooks (that look to the source workbook for changes in data inputs), a...
Summary: a software gets input from port and updates the values in a {MS Access}mdb file. whenever the database is updated i want a selective field of values to be updaed in my excel worksheet. using DDE or wh...
Summary: i have created a worksheet in excel that is used to moniter employees. i want to export the data in to an access database so that i am able to track the employees over a period of time. how can i do t...
0 
