Microsoft Access .MDB and .ACCDB Import Automation Options

Since the Import Options dialog is not displayed when the program is driven from an automation script, an options string can be specified in the script. The string consists of comma-separated parameters, which specify the behavior of the various import options. A typical example would be:

"SQLSTR=, Table=table1"


Option Action Default
SQLSTR Structured Query Language access string. No
Table Name of database table. No

See Also

Microsoft Access Import Options Dialog

Microsoft Access File Description