CONNECT Subcommand (SAVE TRANSLATE command)

CONNECT identifies the database name and other parameters for TYPE=ODBC.

  • The database must already exist. You cannot create a new database with SAVE TRANSLATE (although you can create new tables in an existing database).
  • If you are unsure what the connect string should be, you can use the Export to Database Wizard to generate SAVE TRANSLATE command syntax. (See Export to Database Wizard for more information.) If the connection string is specified on multiple lines, each line must be enclosed in quotes.

Example

SAVE TRANSLATE
   /TYPE=ODBC
   /CONNECT 
   'DSN=MS Access Database;DBQ=C:\examples\data\dm_demo.mdb;'
   'DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;'
   /TABLE='mytable'.