EMS Data Pump for SQL Server is a powerful utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access or any other database with ADO support) to Microsoft® SQL databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target Microsoft® SQL database and select tables for import. Data conversion becomes as easy as possible with EMS Data Pump for SQL Server!
This is a limitation of the trial version which converts only 10% of all records. With a registered version all the records are processed.
The solution to this problem is to use the Microsoft Jet OLE DB Provider for establishing connection to your Access database.