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

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

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
	      semi-column separated list of options:

	      o	 use_index

	      o	 no_memo

	      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

SEE ALSO
       gmdb2(1)	mdb-export(1) mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1)
       mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1)	mdb-tables(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.8.2		       28 February 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