I want to add TimeStamp field while in the process of importing a worksheet from a Excel workbook; however, I want to put this new column in a different column location. I am not allow to do this action.
This only happens when user tries to open and review the template.
This only happens when user tries to open and review the template. If user executes the template directly, the static column will be imported without issue. One more tip: User can preview the data by clicking an Excel Icon button on the upper right corner of perview page, which will open up the Excel file showing the selected data range to import.
Waiting for fix in a future version of Toad for SQL Server.