To update a flattened copy of an ODBC database table, you do not need to import the database table again, simply:
1. | Right-click on the table layout in the Overview |
2. | Select “Refresh from Source”. Analyzer asks if you want to refresh the data from its source. Click [Yes] to update the file. |
Note: If the ODBC database is protected by a password, you will need to provide the password to refresh the data.
Note: Alternatively, if refreshing within a procedure, you can use the Refresh command. For more information, see Refresh.