MDB Converter

Installation:

To run this program you need .Net Framework 2 to be installed. You can download it from here or here.
Just extract the archive to your PC and run the setup.exe file. Install the application
After the installation finished run the application from your desktop.

Converting:

  • To convert a table from an mdb file, choose the source file and click "View Content".
  • In the next window choose the table you wish to convert and Verify the columns - have you chosen the right table?
  • Click one of the "Convert" buttons to convert the file to TXT, CSV or an XML formats

 

To convert all the files in a folder :

  • Click the "Choose Folder" tab.
  • Select a source folder and a target folder
  • Click one of the "Convert" buttons to convert the file to TXT, CSV or XML formats to convert all ".mdb" files in the folder.

How to use MDB Converter in command line:

The format of the command is:

mdbconverter.exe [source type] [source path] [target path] [table name] [target file type]

  • source type -Can be "file" of "folder".Type file to convert a single file or folder to convert a whole folder.
  • source path -The path of the file or folder you want to convert. Make sure your source path don't end with a slash.
  • target path - The target path of the output file/s Make sure your target path don't end with a slash.
  • table name - The name of the table you want to convert or "a" to convert all tables in the file. If you convert a folder you need to type "a".
  • target fie type -Type of the output. Can be equal to "txt", "csv" or "xml".
Example:
mdbconverter.exe file DB.mdb DB.csv MyTable csv
mdbconverter.exe file DB.mdb DB\Output a csv
mdbconverter.exe folder "DB\Source" "DB\Target" a txt

 

What is the difference between the TXT and CSV formats?

TXT format its a regular text file - the text in the target file will be separated by a comma (",") symbol.

CSV format its a special text file - text in the target file will be separated by a semicolon symbol (";"). Each value that contains special characters like inverted commas, spaces or commas will be marked by additional inverted commas.