• Home
• Products
• Full Convert
• Tutorials
• Convert Excel to Access

Convert Excel to Access

Connecting to databases

As we start Full Convert, main form is empty.

Let's create new conversion session. Welcome dialog has a Create new conversion item for this purpose.

Here we will choose Microsoft Excel from the list of available source database formats and fill in connection properties.
If you are unsure, simply leave Automatic engine selected, navigate to your database folder and let Full Convert fill-in the fields for you.

How to fill in the fields:
Type in your Excel document filename or click on the ellipsis (...) button to locate it via file find dialog. Alternatively, you can choose to process all Excel documents in a certain folder.

Clicking Next, we need to select our desired target database.
In this case, we will select Microsoft Access.

How to fill in the fields:
Type in your Access database filename or click on the ellipsis (...) button to locate it via file find dialog.

We will now select tables for conversion.

Please note that you can count rows of tables to easily see where data actually resides. Clicking "Unselect empty" moves all empty tables to 'Do not convert' list.

Clicking "Next" button brings us to the last page in the wizard, the summary.

By default, "I want to convert immediately." option is selected. This is what we want, and will simply press Convert.

Otherwise, you can also choose to only explore target database at this point, as Full Convert has a database explorer built-in.

Full Convert will prompt for confirmation by default, but you can easily set this dialog not to show up anymore.

Pressing Convert button begins the conversion process.

Conversion

You can cancel conversion process anytime. For smaller databases we are done in few seconds.

Customers have reported that Full Convert Enterprise is 10 times faster than competition for certain scenarios. Keep in mind that we support 14 databases and handle their different versions in such a way that the complexity is hidden from the user.

Summary

After conversion is finished, you will be presented with a summary, which you can save.
All eventual errors and warnings (hints) will be shown in a separate tabs for your inspection.

Log files can be saved as well.

You can also inspect and save SQL script generated during the conversion. Possible use for this is further manual inspection of data or use of our automated conversion process in any other desirable application.

Navigating the target database

Navigating structure tree shows us what the target database looks like now. You are now free to do further modifications on structure, rename columns or change their type, drop obsolete columns, extract part of a table to new table etc.