Skip to Content
0

DS sets the character data as when the excle conlum includes number data and character data

Dec 07, 2016 at 01:38 PM

65

avatar image
Former Member

For example:

i want to upload data which from excle file as follows,

column1 column2

1 2

1 2

1 2

1 2

1 2

1 2

1 2

1 2

a 2

a 2

a 2

DS will set ‘a’ as <null> when is view the data from excle source.

Please tell me how to solve this.Thanks very much

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dirk Venken
Dec 07, 2016 at 02:27 PM
0

All depends on the Excel file format defined. If the first column is numeric, it will show null for alphabetic values.
Specify a varchar datatype.

Share
10 |10000 characters needed characters left characters exceeded