Convert Excel to Access with 4TOPS Excel Import Assistant

Introduction

A common situation is where you have initially built a spreadsheet solution in Excel. However, the amount of data keeps growing and you will start to look for a database alternative to make the situation more manageable. Once the structure of the database, its tables and relations, are set up you will have to convert your Excel data. In many cases this is a problem because you will have filled your spreadsheet much more liberally then is supported by the way you set up your Access tables. Problems you will encounter when you convert Excel to access are:

Trying to use Access import spreadsheet wizard you will get loads of ignored records. Therefore you will need a more controlled approach. For this we developed 4TOPS Excel Import Assistant. After mapping Excel columns to Microsoft Access Fields you can start to convert Excel to access 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. By pressing 'Add All' the assistant copies record after record, only stopping if the data can't be added for one of the above reasons. You can then make a correction in the data transfer form showing the current row being importted and continue the processing by pressing 'Add All' again.

Download Excel Import Assistant
Order Excel Import Assistant