4 replies
by mslizny
I think you have solved one problem but created another. You linked the Excel files to Acces, and then created matching tables with identical data so that you could have primary relationships in the table structure of Access. At this point you stepped outside the "linked" structure so that you could use features of Access that only apply to Access tables. Once outside the "linked" structure, you cannot go back to an unlinked status very easily.
As I understand it, you are interested in getting updated information into the "unlinked" tables. I believe you could write a VBA procedure that would re-create the "unlinked" tables and their relationships each time new data comes into the Excel files, or perhaps even get it done with a macro. However, there is nothing otherwise available in Access 97 to accomplish the result you are seeking.
by zapeener
by mslizny
Here are a few more questions for you:
Are the primary keys you created based on information from the Excel tables? If so, the updating process shouldn't append new information unless there are new entries. This would preserve the relationships you have created.
Are you trying to put the new information in the tables with an Update Query? I believe this would be better for your purposes than using some Append process.
by zapeener
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending