We have a database that was created in Access 2002. We need to open the tables in Access 97. There are 19 tables. I realize we can export each table separately, but with 19 tables that need to be updated every week, this is pretty time consuming. I don't know anything about writing code, but I would think someone would know how I can do this task easier than selecting each table in 2002 and File, Export...
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Import tables from Access 2002 into Access 97
- Thread starter MelanieB
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,434
- Office Version
- 365
- Platform
- Windows
Instead of importing or copying, have you tried just linking the tables from one database to the other? The nice thing about linking them is that a change in one place changes the value in both.
From the Tables Object view, simply right click anywhere and select "Link Tables".
I am not sure if going down from Access 2002 to Access 1997 will cause problems. I wouldn't think so, in something as basic as a data table, but I am not certain and no way of testing that on my system.
From the Tables Object view, simply right click anywhere and select "Link Tables".
I am not sure if going down from Access 2002 to Access 1997 will cause problems. I wouldn't think so, in something as basic as a data table, but I am not certain and no way of testing that on my system.
Upvote
0
Similar threads
- Solved
