MDB File Converter

Purpose & User Intent: The MDB file converter ingests MDB Access databases and emits converted artifacts in formats such as ACCDB, CSV, SQLite, JSON, or XML. It targets developers, data engineers, and IT teams performing migrations, data integration, or archival work. Core users value accurate schema and data retention across formats. Core capabilities translate legacy schemas into modern storage representations while preserving essential relationships where supported by the target.
Core Logic & Features: Required features include file upload, source format detection, target format selection, and a conversion engine that preserves table schemas and primary keys where possible. Optional features include batch processing, table subset export, schema-only mode, password‑protected MDB support, data‑type mapping customization, and post‑conversion validation.
Inputs & Outputs: Inputs include file_input (binary), source_format (enum), target_format (enum: CSV, SQLite, ACCDB, JSON, XML), options (object: include_schema, export_data, table_list). Outputs: converted_file (binary or download URL), status, logs. Sample: a 12MB MDB converted to SQLite with schema preserved.
Algorithms & Calculations: The tool maps Access data types to target types (e.g., Text to VARCHAR/TEXT, Memo to TEXT/BLOB, Date/Time to ISO-8601), handles nullability, and preserves table relationships as metadata where supported. It performs data normalization for dates and numeric formats and validates row counts post-conversion.
Error & Edge Cases: Handles invalid or corrupted MDBs by reporting invalid format; encrypted databases require password; large files are chunked; unsupported features trigger warnings; and missing inputs raise errors. External data is not fetched.
Industry/Region & Localization: Uses ISO date standards and locale-aware formatting when exporting localized formats; supports currencies and decimals according to target format. Complies with data privacy expectations: local-only processing when possible.
Assumptions & Exclusions: Assumes input MDB is readable and not irrecoverably corrupted; does not execute Access/VBA code; not intended for real-time replication; does not convert embedded macros unless requested in advanced mode.