Command Line for Opening a Single File

This topic describes parameters of Database Tour command line, specific to opening different files. Some file types (for example, report files) can be opened only in Database Tour Pro.

See also common rules for writing command lines.

Usage

dbtour.exe FileNameToOpen

The action that Database Tour will take with a file passed to it depends on the file type.

Note: When you drag and drop a file onto an open Database Tour window or onto the Database Tour icon on your desktop, much the same mechanism is used.

Examples

  • Open a .dbf file:

    dbtour.exe "c:\my db\customer.dbf"

    Database Tour first opens the folder containing the specified file, then opens the corresponding DBF table in a separate tab.

  • Open a .csv file:

    dbtour.exe c:\payments\jun2013.csv

    Database Tour will first open the folder containing the specified file, then open the corresponding CSV table in a separate tab.

  • Open an .mdb file:

    dbtour.exe "c:\my db\MyData.mdb"

    Database Tour will open the specified file and display a list of tables in it. You can then work with the opened file as a database.

  • Open an .accdb file:

    dbtour.exe "c:\my db\MyData.accdb"

    Database Tour will open the specified file and display a list of tables in it. You can then work with the opened file as a database.

  • Open an .xlsx file:

    dbtour.exe "c:\my db\MyData.xlsx"

    Database Tour will open the specified file and display a list of tables in it. You can then work with the opened file as a database, but in read-only mode.

  • Open a dynamic report (Database Tour Pro only):

    dbtour.exe c:\MyReports\Invoices.dtt

    Database Tour will open the database specified in the report file, then open the report dataset, and then open the report in the report builder. From the designer, you can easily preview the report and print it.

  • Open a static report (Database Tour Pro only):

    dbtour.exe c:\MyReports\Invoices.stt

    Database Tour will open the report in a preview window.

  • Open an .sql file:

    dbtour.exe c:\MyReports\Invoices.sql

    Database Tour will open the file in the SQL Editor window.

Notes

  • It is recommended to use full file names.
  • If the file name includes spaces, enclose it in quotes.