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