![]() On the Home tab, in the Number Format box, select the format "Text", so that all cells in the selected column now have this formatting.Open the Excel sheet and select the column of which cells have different formatting.This is an indication where to look in the Excel sheet. As can be seen in the figure above, the error message indicates to which data the error applies. ![]() These differences in formatting may not always be visible. ![]() The error message is caused by the fact that the cells in one or more data columns in the Excel sheet have different formatting. Example of an Excel connection, Excel sheet, and error message: When importing data from an Excel ® sheet into Enterprise Studio using an Excel connection, a script error message appears about values not being compatible, and the import fails.
0 Comments
Leave a Reply. |