Download 4TOPS Excel Import Assistant

Brief Description

4TOPS Excel Import Assistant is an add-in for Microsoft Access that enables you to import data from Excel in Access in a controlled way. Moving row after row through your Excel table(s) you can instantly fill in missing data or alter erroneous data before transferring them to your database. Note: the 64bits version is for Office 64 bits versions.

Quick Details

  Access 2016 / 2019 / 365 Access 2013 Access 2010  
   32bits  64bits 32bits 64bits 32bits 64bits Access 2007
Version 6.0 6.0 6.0 6.0 6.0 6.0 6.0
Date published 6nov15 6nov15 1may14 1may14 29dec15 15oct12 14dec10
Size 3.302kb 3.302kb 3.370kb 3.370kb 2.897kb 2.760kb 2.690kb

Instructions for use:

  1. After downloading the zip file you have to extract it. Inside you will find the Help file .chm and the Add-In: .mda or .accda.
  2. 4TOPS Excel Import Assistant is an Access Add-In, so first you have to install it using the Add-In Manager. add-in manager
  3. Unblock Help file
    If the help file does not show this is caused by Windows security. To solve this:
    1. Locate the Help file in the folder where you installed
    2. Right-click on it and select Properties
    3. Click Unblock
    From now on the Help file will be ok.
  4. After installing you can start using the Add-In. With Access 2007 and higher:
    1. Open the database you want to import into
    2. On the ribbon, tab Database Tools, group Database Tools, click on Add-Ins.
    3. Start the Import Assistant from the ribbon, tab Database Tools, group Add-Ins, click on Add-Ins and select 4TOPS Excel Import Assistant.
    On Access 2000 - 2003 you start from menu > database tools > add-ins
  5. The best way to get acquainted with the software is combined use of tutorials in the help and the learning/test database: Download

The more informative way to use the demo is to manually start each demo import by following the tutorials in the help.

Tip: a safe and efficient way to try the add-in is to use it in a copy of your database. Alternatively, try it on our test database