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
Filename 4txlim16.zip
4txlim16-64bits.zip 4txlim15.zip
4txlim15-64bits.zip 4txlim14.zip 4txlim14-64bits.zip 4txlim12.zip
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 xlimtest.zip

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