Microsoft Office Marketplace logo



 
Single user USD199 EUR137 GBP134
Available for the platforms Microsoft Access 97, Microsoft Access 2000, Microsoft Access XP/03 and Microsoft Access 07 Supports Microsoft® Office 2007.

'I just want to tell you that the Excel Import Assistant is saving my bacon on my current project! This is a great tool.' Alton Brisbane, Jr. Tspec Solutions

Use 4TOPS Excel Link for Microsoft Excel mail merge.

 

4TOPS Excel Import  

Excel Import helps you import Excel data into your database.

  • Add and/or replace (merge) data
  • Ability to import multiple files in a batch
  • Import from table and individual cells
  • Import multiple worksheets in one file

The software uses Microsoft® Access® to connect to both the source data and the destination database. So it is necessarily you have Access installed. Use the wizard to set up the import easily.

This product replaces the old 4TOPS Excel to Access Import Assistant.

Data Validation

  • Add or Replace, depending on whether the record already exists or not.
  • The new values are compared with the old during the import. The changes are identified.
  • Interact with the data during the import session to correct errors or to add missing information.
  • The system diagnoses which field prevents importing a record, you can fix values directly on screen. Field matching problems as not corresponding types, referential integrity, in general the reasons why update queries fail.
  • Has a 'Continue if errors' checkbox. Catch records that fail to import during the import, know why, fix and reimport.

Complex imports

  • Convert the imported values using lookup or custom written functions (VBA)
  • Record by record or batch imports
  • Add records in parent / child relation, e.g. Order with Order lines.
  • Change and extend Import specifications whenever needed
  • Improved speed
  • Import log: see which imports were done when, by whom and how many records were processed.

Support

For any questions or requests concerning this product or to all other 4TOPS products please contact support@4tops.com.

Installation

The download uses self-extracting technology for easy installation.
download Microsoft Access Excel import wizard

Excel Import Assistent für Microsoft Access

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.