Connecting Interactive Excel to an Access Database 
Connecting Interactive Excel to an Access Database
Prerequisites
You have opened an empty or predefined file that was created using the Interactive Excel template.
Procedure
1. Choose SAP ® Logon ® Other MS Access Database.
In the following dialog box, enter your user name and password for the offline data entry program and specify the relevant database file and path, if necessary using the Browse function.
The entries that you make here are saved as defaults for the next time you log on. You only need to reenter the password.
If an authorization check is active for the Access database in the Microsoft environment, choose More. Check the default values in the additional fields and change the Access user name and password if required.
2. Choose Open.
Result
You are connected to the database and a menu option, which refers to the linked SAP application (for example Consolidation, Strategic Enterprise Management), is added to the standard Excel menu.
Additional functions appear under the menu item SAP, such as Read values automatically, Settings, or Data origin.