This is shown below in the animated image. Right clicking a table allows you to add tables related to that table. Choose any table by clicking the dropdown. The database won't open, however you would a new screen with one table from the Database and the fields inside that table.
Press 'Select Access Database' button to locate and select your access database. View Related Tables and Pull Raw Data from Related Tables Once installed you will see a new tab 'Z-Tools' in your excel workbook. Activate the 'Z-Tools' Tab and press 'Pull Data from Access” ButtonĪ dialog form would appear as shown below Open any excel workbook. Press ALT + T + I to open the Addin Manager. Browse for the file and enable the Addin
STEP BY STEP INSTRUCTIONS TO USE 'PULL FROM ACCESS' ADDIN How to Install this Addin There is no need to download again if you have already downloaded “Z-Addin” from another webpage in this website Please provide email address so that if there is any improvement in this Addin, I can share it with you ? You can download the copy of this Addin from the link below. If you have any difficulty retrieving information or using this Addin, please write to me at Download Using this Addin, users can retrieve, summarize, query the database and even view, modify and run their SQL codes without the need to open the ACCESS database. Especially when Multiple Users need to simultaneously access in real time. This Addin is particularly very useful when you need to share your Access Database with Multiple Users on a read only basis.
Group Dates by Months, Quarters and Years.View and run stored queries in the Database.Summarize, Aggregate and Group Data like a pivot table in many interesting ways.View Related Tables and Pull Raw Data from Related Fields.Just download and play with the features. The Addin itself is very intuitive and easy to use. I have given animated images in most cases to show how it works. Click any feature below to see how to use it.