View MDB/ACCDB Files Online & Convert to CSV

import pandas as pd
import pyodbc

# Connect to MDB
conn_str = (
    r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};'
    r'DBQ=C:\data\sample.mdb;'
)
conn = pyodbc.connect(conn_str)

# Read table to DataFrame
df = pd.read_sql('SELECT * FROM Customers', conn)
print(df.head())

# Export to CSV
df.to_csv('customers.csv', index=False)
conn.close()

Install: pip install pandas pyodbc

import subprocess
import pandas as pd

# Get table names
tables = subprocess.check_output(
    ['mdb-tables', '-1', 'sample.mdb']
).decode().split('\n')

# Export table to CSV
subprocess.run([
    'mdb-export', 'sample.mdb', 'Customers'
], stdout=open('customers.csv', 'w'))

# Read CSV with pandas
df = pd.read_csv('customers.csv')
print(df.head())

Requires: mdbtools installed

const MDBReader = require('mdb-reader');
const fs = require('fs');

// Read MDB file
const buffer = fs.readFileSync('sample.mdb');
const reader = new MDBReader(buffer);

// Get table names
const tables = reader.getTableNames();
console.log('Tables:', tables);

// Read table data
const table = reader.getTable('Customers');
const data = table.getData();

console.log(`Rows: ${data.length}`);
console.log(data[0]);

// Write to JSON
fs.writeFileSync(
    'customers.json', 
    JSON.stringify(data, null, 2)
);

Install: npm install mdb-reader

using System.Data.Odbc;

string connString = 
    "Driver={Microsoft Access Driver (*.mdb)};" +
    "Dbq=C:\\sample.mdb";

using (var conn = new OdbcConnection(connString))
{
    conn.Open();
    var cmd = new OdbcCommand(
        "SELECT * FROM Customers", conn);
    
    using (var reader = cmd.ExecuteReader())
    {
        while (reader.Read())
        {
            Console.WriteLine(
                $"{reader["CustomerID"]}: " +
                $"{reader["CompanyName"]}"
            );
        }
    }
}

Requires: Microsoft Access Database Engine

import net.ucanaccess.jdbc.*;
import java.sql.*;

public class ReadMDB {
    public static void main(String[] args) {
        String url = "jdbc:ucanaccess://C:/data/sample.mdb";
        
        try (Connection conn = DriverManager.getConnection(url);
             Statement stmt = conn.createStatement();
             ResultSet rs = stmt.executeQuery(
                 "SELECT * FROM Customers")) {
            
            while (rs.next()) {
                System.out.println(
                    rs.getString("CustomerID") + ": " +
                    rs.getString("CompanyName")
                );
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

Add to pom.xml: net.sf.ucanaccess

<?php
// Using ODBC
$conn = odbc_connect(
    "Driver={Microsoft Access Driver (*.mdb)};".
    "Dbq=C:\\data\\sample.mdb", 
    "", ""
);

$sql = "SELECT * FROM Customers";
$result = odbc_exec($conn, $sql);

while ($row = odbc_fetch_array($result)) {
    echo $row['CustomerID'] . ": " . 
         $row['CompanyName'] . "\n";
}

odbc_close($conn);
?>

Requires: ODBC extension enabled in php.ini

require 'dbi'

# Connect to MDB via ODBC
conn = DBI.connect(
  'DBI:ODBC:DRIVER={Microsoft Access Driver (*.mdb)};' +
  'DBQ=C:\\data\\sample.mdb'
)

# Query data
rows = conn.select_all(
  'SELECT * FROM Customers'
)

rows.each do |row|
  puts "#{row['CustomerID']}: #{row['CompanyName']}"
end

conn.disconnect

Install: gem install dbi dbd-odbc

# Connect to MDB
$connString = "Driver={Microsoft Access Driver (*.mdb)};" +
              "Dbq=C:\data\sample.mdb"
$conn = New-Object System.Data.Odbc.OdbcConnection($connString)
$conn.Open()

# Query data
$cmd = $conn.CreateCommand()
$cmd.CommandText = "SELECT * FROM Customers"
$reader = $cmd.ExecuteReader()

while ($reader.Read()) {
    Write-Host "$($reader['CustomerID']): $($reader['CompanyName'])"
}

$conn.Close()

Built-in with Windows

#!/bin/bash
# Using mdb-tools

# List all tables
mdb-tables sample.mdb

# Show table schema
mdb-schema sample.mdb

# Export table to CSV
mdb-export sample.mdb Customers > customers.csv

# Export all tables
for table in $(mdb-tables sample.mdb); do
  mdb-export sample.mdb "$table" > "$table.csv"
  echo "Exported: $table"
done

Install: sudo apt install mdbtools

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/alexbrainman/odbc"
)

func main() {
    connStr := "Driver={Microsoft Access Driver (*.mdb)};" +
               "Dbq=C:\\data\\sample.mdb"
    
    db, err := sql.Open("odbc", connStr)
    if err != nil {
        panic(err)
    }
    defer db.Close()
    
    rows, _ := db.Query("SELECT * FROM Customers")
    defer rows.Close()
    
    for rows.Next() {
        var id, name string
        rows.Scan(&id, &name)
        fmt.Printf("%s: %s\n", id, name)
    }
}

Install: go get github.com/alexbrainman/odbc

library(RODBC)

# Connect to MDB
conn <- odbcConnectAccess("C:/data/sample.mdb")

# Read table into data frame
customers <- sqlFetch(conn, "Customers")
print(head(customers))

# Query with SQL
orders <- sqlQuery(conn, 
    "SELECT * FROM Orders WHERE OrderDate > #2023-01-01#")

# Export to CSV
write.csv(customers, "customers.csv", row.names=FALSE)

# Close connection
odbcClose(conn)

Install: install.packages("RODBC")

Sub ReadMDB()
    Dim conn As Object
    Dim rs As Object
    
    Set conn = CreateObject("ADODB.Connection")
    conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
              "Data Source=C:\data\sample.mdb"
    
    Set rs = CreateObject("ADODB.Recordset")
    rs.Open "SELECT * FROM Customers", conn
    
    ' Write to Excel
    Range("A1").CopyFromRecordset rs
    
    rs.Close
    conn.Close
End Sub

Built-in with Microsoft Office