EnglishFrenchSpanish

Ad


OnWorks favicon

mdb-export - Online in the Cloud

Run mdb-export in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command mdb-export that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

PROGRAM:

NAME


mdb-export - Export data in an MDB database table to CSV format.

SYNOPSIS


mdb-export [-H] [-d delimiter] [-R row_delim] [[-Q] | [-q quote [-X escape]]] [-I backend] [-D format] [-N namespace] [-b strip|raw|octal] database table

DESCRIPTION


mdb-export is a utility program distributed with MDB Tools.

It produces a CSV (comma separated value) output for the given table. Such output is
suitable for importation into databases or spreadsheets.

OPTIONS


-H Suppress header row

-Q Don't wrap text-like fields (text, memo, date) in quotes. If not specified text
fiels will be surrounded by " (double quote) characters.

-d Specify an alternative column delimiter If no delimiter is specified, table names
will be delimited by a , (comma) character.

-R Specify a row delimiter

-I backend
INSERT statements (instead of CSV). You must specify which SQL backend dialect to
use. Allowed values are: access, sybase, oracle, postgres, mysql and sqlite.

-D Set the date format (see strftime(3) for details)

-q Use to wrap text-like fields. Default is ".

-X Use to escape quoted characters within a field. Default is doubling.

-N namespace
Prefix identifiers with namespace.

-b strip|raw|octal
Binary export mode: strip binaries, export as-is, or output style octal data.

NOTES


ENVIRONMENT


MDB_JET3_CHARSET
Defines the charset of the input JET3 (access 97) file. Default is CP1252. See
iconv(1).

MDBICONV
Defines the output 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:

· use_index

· no_memo

· debug_like

· debug_write

· debug_usage

· debug_ole

· debug_row

· debug_props

· debug_all is a shortcut for all debug_* options

Use mdb-export online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    wxPython
    wxPython
    A set of Python extension modules that
    wrap the cross-platform GUI classes from
    wxWidgets.. Audience: Developers. User
    interface: X Window System (X11), Win32 ...
    Download wxPython
  • 2
    packfilemanager
    packfilemanager
    This is the Total War pack file manager
    project, starting from version 1.7. A
    short introduction into Warscape
    modding: ...
    Download packfilemanager
  • 3
    IPerf2
    IPerf2
    A network traffic tool for measuring
    TCP and UDP performance with metrics
    around both throughput and latency. The
    goals include maintaining an active
    iperf cod...
    Download IPerf2
  • 4
    fre:ac - free audio converter
    fre:ac - free audio converter
    fre:ac is a free audio converter and CD
    ripper for various formats and encoders.
    It features MP3, MP4/M4A, WMA, Ogg
    Vorbis, FLAC, AAC, and Bonk format
    support, ...
    Download fre:ac - free audio converter
  • 5
    BotMan
    BotMan
    Write your chatbot logic once and
    connect it to one of the available
    messaging services, including Amazon
    Alexa, Facebook Messenger, Slack,
    Telegram or even yo...
    Download BotMan
  • 6
    gerbv  a Gerber (RS-274X) viewer
    gerbv a Gerber (RS-274X) viewer
    Gerbv is an open source Gerber file
    (RS-274X only) viewer. Gerbv lets you
    load several files on top of each other,
    do measurements on the displayed image,
    etc. ...
    Download gerbv a Gerber (RS-274X) viewer
  • 7
    Iometer
    Iometer
    I/O performance Analysis Tool.
    Audience: Developers, Information
    Technology, Science/Research, System
    Administrators. User interface: Win32
    (MS Windows). Progr...
    Download Iometer
  • More »

Linux commands

Ad