Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications.
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form.
The conversion of Access to CSV using Full Convert is simple and has to do a few quick steps:
When we start Full Convert, you will notice a welcome panel with links for common tasks. Let's start a new conversion.
Click the Create new conversion link or click the New button in the ribbon above.
Initial screen shows you that Full Convert will automatically detect your database if you don't know which one do you have. Of course, if you do know your database, do select it from the list on the left.
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.
List on the left shows all the databases which can be filled with your source database data. Select the one you need and fill-in required parameters.
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.
We will select all source tables for conversion by default. In case you only need some tables, simply deselect the ones you don't need - or deselect all, then select just the tables you do need.
Here you can see how many tables will be converted. To start conversion right away, click on the Convert! button. To show contents of target database without converting, click on the Explore button. Use that to inspect target database prior to conversion, or to save the conversion project for later before even converting the first time.
Click the Convert! button to get started.
Conversion is highly-optimized to run as fast as possible, yet provides top-notch reliability. Huge tables are converted in small chunks at a time, preserving memory and ensuring that your computer stays fast and responsive.
Here you will see basic conversion statistics, such as number of tables and records copied to target database.
If there were any warnings or errors during conversion, you will be able to examine them in detail.
Finally, complete SQL log is available for you if you need it. This feature can be enabled in options dialog.
This small tutorial shows how easy it is to convert Access to CSV using Full Convert Enterprise.
If you like what you see, please purchase Full Convert at our site. Delivery is instant via email, and with 30 day money-back guarantee there is no risk in purchasing.
Also, if you want to make sure our applications fits your needs before buying, you can download free trial version.