Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
mdb-import(1)	     Executable	programs or shell commands	 mdb-import(1)

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).

       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:

	      o	 debug_like

	      o	 debug_write

	      o	 debug_usage

	      o	 debug_ole

	      o	 debug_row

	      o	 debug_props

	      o	 debug_all is a	shortcut for all debug_* options

	      o	 no_memo (deprecated; has no effect)

	      o	 use_index (experimental; requires libmswstr)

SEE ALSO
       mdb-array(1) mdb-count(1)  mdb-export(1)	 mdb-header(1)	mdb-hexdump(1)
       mdb-json(1)  mdb-parsecsv(1)  mdb-prop(1)  mdb-queries(1) mdb-schema(1)
       mdb-sql(1) mdb-tables(1)	mdb-ver(1)

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  con-
       straints.

MDBTools 0.9.3		       21 September 2021		 mdb-import(1)

NAME | SYNOPSIS | DESCRIPTION | OPTIONS | NOTES | ENVIRONMENT | SEE ALSO | HISTORY | AUTHORS | BUGS

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=mdb-import&sektion=1&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help