Skip to content

Export/Import Command Line Parameters

To run the Export/Import utility from the command line, run expimp32.exe. It supports the following command line parameters.

Note

  • Unless you include the /S parameter, the Export/Import Utility dialog box appears, displaying the values specified by the command line parameters.

  • All tables in the database are included by default.

  • Unless you specify otherwise, an ini file is the default format, empty tables are not included in the data file, and a detail file is not created.
/D filename Export the specified data file. The file is created in the current directory unless you specify a different drive and directory. A file extension is not needed.You can include either the /D or the /I command line parameter. If you include both, only the /D command line parameter is used.
/I filename Import the specified data file. The file is imported from the current directory unless you specify a different drive and directory. A file extension is not needed. You can include either the /D or the /I command line parameter. If you include both, only the /D command line parameter is used.
/A directory Specifies the location of the InfoConnect database to be exported or imported. If you omit this command line parameter, the database specified by the Windows registry is used.
/FC Use csv format for the data file.
/FI Use ini format for the data file.
/OD Create a detail file. If you include the /S command line parameter, you must include both the /D and the /OD command in order to create a detail file. The detail file will have the same name as the data file, but will have a *.dtl extension.
/OE Include empty tables in the data file.
/OT Include empty tables in the detail file.
/S Run in silent mode (no dialog box or message box appears). To run the utility in silent mode, you must also include either the /D or the /I command line parameter.
/B1 Use a 16-bit INFOConnect database.

For example, the following command exports the current database. It shows no user interface and creates a file called icdata.ini.

expimp32 /S /D c:\icdata.ini

The following command imports content from the icdata.ini file into the current database

expimp32 /S /I c:\mypath\icdata.ini