CSV to MDB

This command line tool will convert a single CSV file into a table in an Access database (MDB format). Features include

  • making an educated guess about the column types and sizes. It currently supports integer, double, date and text columns.
  • You can specify the primary key for the table.
  • Compacts the database as it is being populated, since the database can get large very quickly when there are a lot of records.

CSV to MDB application

Usage is CsvToMdb.exe csvFile [primary key]

Download the application (requires .NET Framework 2.0)

Download the source code (requires Visual Studio 2010)