Hi all,
I have a question regarding the formatting of SQL data the is retrieved with ODBC data link.
When I run the query in SQL this is the data returned:
<tbody>
</tbody>
When I do the same using an ODBC connection I get this as result:
<tbody>
</tbody>
I tried to set the Excel format to display all as text but without success.
Any suggestions as to how I can see the real results and not the scientific notation in the second column would be appreciated.
I have a question regarding the formatting of SQL data the is retrieved with ODBC data link.
When I run the query in SQL this is the data returned:
CRM_Ref_ID | i3_identity | callid |
7184428:L | 570160726000750950 | 2001343998 |
5727866:P | 570160726000709579 | 2001344950 |
<tbody>
</tbody>
When I do the same using an ODBC connection I get this as result:
CRM_Ref_ID | i3_identity | callid |
7184428:L | 5.70161E+17 | 2001343998 |
5727866:P | 5.70161E+17 | 2001344950 |
<tbody>
</tbody>
I tried to set the Excel format to display all as text but without success.
Any suggestions as to how I can see the real results and not the scientific notation in the second column would be appreciated.