If you want to refresh the data in the same Minitab worksheet every time you run the Exec file, you need to edit the Exec file to specify the columns to use in the Minitab worksheet.
The maximum number of characters that can occur between double quotation marks on one line is 80. To use text strings longer than 80 characters, break the string into smaller sections across multiple lines using the ampersand (&) key. For example, in the following Session window output, the ampersand is inserted to continue two long text strings in double quotation marks down to the next line.
MTB > ODBC; SUBC> Connect "DSN=Excel Files;DBQ=C:\DOCUMENTS AND SETTINGS\JSMITH\DESKTOP\jon" & CONT> "athon.xls;DefaultDir=C:\DOCUMENTS ANDSETTINGS\JSMITH\DESKTOP;DriverId=345" & CONT> ";MaxBufferSize=2048;PageTimeout=5;";
You can specify a range of column IDs instead of naming each one individually, for example: Columns C1-C10. Specifying a range is especially useful when importing a large number of columns.