Full Convert

Conversion of Access database to CSV text using Full Convert

Purpose of this tutorial is to show you basic use of Full Convert Enterprise. To learn about advanced features such as built-in scheduler, data type customization, project customization rules, logging etc., take a look at the video tutorials.

The Access to CSV text conversion using Full Convert is easy and you need to do just a few quick steps:
  1. Connect to your source and target database
  2. Optional: Choose which tables you want to convert (by default, all are selected)
  3. Start the conversion, sit back and enjoy
  4. Optional: Explore your brand new data in the target database, using a built-in database explorer

1. Connecting to databases

As we start Full Convert, you will notice a welcome panel with links for common tasks.
Let's create new conversion session. Click on the Create new conversion link, or click on the New button on the ribbon above.

Start new project

Selecting source database
We will choose Access database from the list of available source database formats and fill in connection properties. You can simply click ellipsis (...) button to select MDB or ACCDB database file. It depends on the version of your database. Access 2007 databases are contained in ACCDB files, while earlier versions are contained in MDB files. If your Access database is protected, fill-in your password as well. In case you use Access workgroups and security, you will need to also find your system database and specify username/password for it.

Selecting target database
From the list of available target database engines, we'll choose Text. You can simply click ellipsis (...) button to select the folder to contain converted delimited text files. Default delimiter is Comma (use it if you have comma-delimited files), but you can change it to Tab (for tab-delimited files), or any other character.

2. Selecting tables to convert. All by default.

We will now select tables for conversion. All tables in the right list will be converted from Access to CSV text. 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. We will just leave this on to start right away. Otherwise, you can also choose to only explore target database at this point (as Full Convert has full-fledged database/data explorer built-in) and simply press Convert! button in ribbon when ready.

3. Conversion

Full Convert is very fast. We use dedicated native database components instead of relying on translation libraries like ODBC which incur performance hit and often have bugs of their own. Reaching transfer of 20.000 records per second is not uncommon. Of course, that speed can't be reached with slow databases (like Access, for example), when large binary data is in table, or when network lag is an issue.

Conversion progress

Detailed summary

After Access to CSV text conversion is finished, you will be presented with a summary. If errors occur, you will be able to inspect then in a separate tab. If appropriate, we will provide you with suggestions of how to further speed up transfer or avoid errors in conversion. Also, you can choose to have SQL commands displayed, so you can explore the generated SQL script and save it for use in your other database tools.
Have you noticed that we migrated 700k records in less than a minute? By the way, Full Convert handles databases of unlimited size!

Conversion summary

Navigating the target database

Navigating structure tree shows us what the target database looks like now. You are 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.
You can also explore the data of each table, edit the data directly in the powerful grid, import/export cell values from/to disk and more.

Navigating target database after conversion

That's all for this basic Access to CSV text conversion tutorial. Full Convert is very powerful - it's very easy to use, but offers much more than presented here.
We invite you to explore Full Convert more, and, of course, to purchase it. If you want to test it yourself, just download a free trial.

Purchase OnlineDownload Free Trial
Used by thousands
Our Clients
"During Q4 of 2009 I was involved in a very large conversion project form MySQL Server to SQL Server 2008 Enterprise Edition. The database I converted from MySQL was from 40GB to about 500 GB.
The support provided by Spectral Core was fantastic, second to none.

I have no issues recommending this product without which it would have taken my conversion project much much longer to complete and I wanted to specially thank Damir Bulic for providing one of the best customer support I've ever encountered."
Dave Shrestha
IT Engineering: Platform Engineering
Oracle/SQL DBA
intel (r) Corporation