Convert MDB to VCF

A phone, email client, or contact manager may accept vCards but not Microsoft Access databases. Converting the contact records to VCF makes them importable on those systems, while the original MDB remains available for database use.

What the MDB format is

MDB is the Microsoft Access database format used by Access 2003 and earlier and by many older Windows applications. Later Access versions can still open and create MDB files when the older database format is selected.

An MDB file can contain tables, queries, forms, reports, relationships, indexes, attachments, and VBA code. Contact information is usually stored in one or more related tables containing names, email addresses, telephone numbers, organizations, and postal addresses. Access databases are used by small businesses, address-book systems, accounting applications, and archived line-of-business software.

Open the file in Microsoft Access when possible. A contact query may be more suitable than a single table if names and telephone or address fields are distributed across related tables.

What the VCF format is

VCF is the common filename extension for vCard, a text-based contact interchange format. A file can contain one or multiple contact records, with each record enclosed by BEGIN:VCARD and END:VCARD.

vCard supports names, formatted names, email addresses, telephone numbers, organizations, job titles, postal addresses, notes, birthdays, URLs, and, depending on the version and application, photographs. Phones, email clients, desktop address books, and contact-sync services commonly import it.

VCF stores contact properties, not Access database objects. Tables, queries, forms, reports, relationships, permissions, VBA code, and columns without a vCard equivalent are not preserved.

Convert MDB with Microsoft Access and a VCF exporter

1. Make a backup copy of the MDB. Open the copy in Access and use Database Tools → Compact and Repair Database if Access reports database damage. Do not repair the only copy.
2. Open the contact table or create a query that returns one complete contact per row. Select fields such as FirstName, LastName, Email, Mobile, HomePhone, WorkPhone, Company, JobTitle, Street, City, State, PostalCode, and Country. Exclude internal IDs and unrelated database fields.
3. Export the table or query through External Data → Export → Text File. Select a delimited export, use comma as the delimiter, include field names, and save it as contacts.csv. Choose UTF-8 when the Access version provides an encoding option; otherwise convert the exported file to UTF-8 before importing it.
4. Import the CSV into a contact application that can export vCard. Mozilla Thunderbird with the CardBook extension can import CSV, map columns to contact properties, and export selected contacts as VCF. Create or select a CardBook address book, use its import command, choose contacts.csv, and map each phone column separately to mobile, home, or work.
5. Inspect several imported contacts, then export them from CardBook as contacts.vcf. Select vCard 3.0 for older phones and applications; select vCard 4.0 only when the receiving software supports it.

Access does not provide a general native command that converts an arbitrary table directly to VCF. The CSV stage exposes the field mapping and prevents unrelated MDB objects from being treated as contacts.

Automate recurring conversions

On Windows, a script can read MDB through the Microsoft Access Database Engine or an ODBC driver and generate vCards with a library such as Python vobject. Install a driver whose 32-bit or 64-bit architecture matches the Python process, then install the Python packages with:

py -m pip install pyodbc vobject

Query the contact table with parameterized SQL, create one vCard object per row, map names to N and FN, addresses to ADR, email addresses to EMAIL, and telephone numbers to TEL, and serialize the cards into one VCF file. Handle null values, embedded line breaks, duplicate records, and character encoding explicitly.

On Linux, mdbtools can extract many unencrypted MDB tables before a script creates the VCF:

mdb-export contacts.mdb Contacts > contacts.csv

mdbtools may not support every Access query, encryption mode, attachment, linked table, or complex data type. Microsoft Access or the Access Database Engine is the safer reader for files that depend on those features.

Use an online converter

For non-confidential files, services such as Zamzar and Convertio may provide MDB-to-CSV conversion when that format pair is present in their current format lists. Upload the MDB, choose CSV, download the result, and pass the CSV through a CSV-to-VCF converter or a contact application with VCF export. Online services often do not expose reliable field mapping, may not support encrypted or damaged MDB files, and may produce CSV rather than VCF directly.

Do not upload customer, employee, medical, or private address-book data without authorization. Delete uploaded files and downloaded temporary copies according to the service's retention controls, and inspect the resulting VCF before importing it elsewhere.

Quality and compatibility checks

• Export a query instead of a raw table when contact data is split across related tables. An incorrect join can create incomplete or duplicate contacts.
• Map fields manually. A database column named Phone may mix mobile, home, and work numbers, while vCard represents them as separate properties.
• Check accented and non-Latin names, quoted commas, apostrophes, multiline notes, and address line breaks after the CSV import. Preserve Unicode as UTF-8.
• Normalize telephone numbers, preferably with an international country code, when contacts will be used across countries. Exporters cannot safely infer a country code from a local number.
• Memo fields, attachments, calculated values, linked-table values, custom VBA data, and Access-specific metadata may be omitted or reduced to plain text. Keep the MDB as the authoritative source.
• A combined VCF is convenient for bulk import, but some older devices accept only one contact per file. If necessary, export individual VCF files or split the file at each BEGIN:VCARD block without altering its line endings.