Trying to update values in a table through data grid. The new values are copied from multiple consecutive cells from one column in Microsoft Excel worksheet, and then paste into the column in the data grid. Upon pasting into data grid, all the values are merged into one cell, instead of beingin the respective cells.
e.g. copied values
123
456
789
when pasted into the data grid, the values become
123456789
Product defect
WORKAROUND:
To copy cell by cell from the Excel worksheet, and then paste into data grid.
STATUS:
Waiting for a fix in a future release of Toad for SQL Server.
