---
name: "mdb-import"
section: "1"
platform: "linux"
package: "mdbtools"
version: "1.0.1-0.1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/mdb-import"
---

# mdb-import(1)

Import CSV data into an MDB database.

## NAME

**mdb-import** - Import CSV data into an MDB database.

## SYNOPSIS

```
mdb-import [-H lines] [-d char] database table csvfile
mdb-import -h|--help
mdb-import --version
```

## DESCRIPTION

**mdb-import is a utility program distributed with MDB Tools.**

**It reads a CSV (comma separated value) file and add the data into** *table* **of** *database***.**

## OPTIONS

- **-H, --header *lines***

  **Skip** *lines* **of CSV header.**

- **-d, --delimiter *char***

  **Specify an alternative column delimiter. Default is , (comma).**

- **--version**

  **Print the mdbtools version and exit**

## NOTES

## ENVIRONMENT

- **MDB\_JET3\_CHARSET**

  **Defines the charset of the JET3 (access 97) file. Default is CP1252. See [iconv(1)](/iconv/1.md).**

- **MDBICONV**

  **Defines the input charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv.**

- **MDBOPTS**

  **Colon-separated list of options:**

  - •

    **debug\_like**

  - •

    **debug\_write**

  - •

    **debug\_usage**

  - •

    **debug\_ole**

  - •

    **debug\_row**

  - •

    **debug\_props**

  - •

    **debug\_all is a shortcut for all debug\_\* options**

  - •

    **no\_memo (deprecated; has no effect)**

  - •

    **use\_index (experimental; requires libmswstr)**

## SEE ALSO

**[mdb-array(1)](/mdb-array/1.md) [mdb-count(1)](/mdb-count/1.md) [mdb-export(1)](/mdb-export/1.md) [mdb-header(1)](/mdb-header/1.md) [mdb-hexdump(1)](/mdb-hexdump/1.md)** **[mdb-json(1)](/mdb-json/1.md) [mdb-parsecsv(1)](/mdb-parsecsv/1.md) [mdb-prop(1)](/mdb-prop/1.md) [mdb-queries(1)](/mdb-queries/1.md)** **[mdb-schema(1)](/mdb-schema/1.md) [mdb-sql(1)](/mdb-sql/1.md) [mdb-tables(1)](/mdb-tables/1.md) [mdb-ver(1)](/mdb-ver/1.md)**

## HISTORY

**mdb-import first appeared in MDB Tools 0.7.**

## AUTHORS

**The mdb-import utility was written by Brian Bruns.**

## BUGS

**mdb-import does not enforce any kind of checks. You can violate constraints.**