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.
In an ODBC SQL or connect string, the maximum number of characters that can occur between double quotation marks on one line is 80. To use text strings that are longer than 80 characters, break the string into smaller sections across multiple lines using the ampersand (&) key. For example, in the following Session window content, the ampersand continues a long text string in double quotation marks down to the next line.
MTB > ODBC; SUBC> Connect "DSN=Excel Files;DBQ=C:\DOCUMENTS AND SETTINGS\JSABARA\DESKTOP\jon" & CONT> "athon.xls;DefaultDir=C:\DOCUMENTS AND SETTINGS\JSABARA\DESKTOP;DriverId=345" & CONT> ";MaxBufferSize=2048;PageTimeout=5;";
You can specify a range of column IDs instead of naming each column individually (for example: Columns C1-C10). Specifying a range is especially useful when you import a large number of columns.