ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel query via ODBC cuts values (https://www.excelbanter.com/excel-discussion-misc-queries/66032-excel-query-via-odbc-cuts-values.html)

escelinen

Excel query via ODBC cuts values
 

I have a problem when I importing data with Excel 2003 query from
Informix with ODBC. Preview shows everything ok but when importing data
to the Excel sheet it "cuts" numbers randomly from the end of value. For
example if the value to import is 14, preview shows it right but there
is only value 1. So number 4 is cutted off. No matter if the value or
string is long or short. Data contains over 40 000 rows.

Any suggestions?


--
escelinen
------------------------------------------------------------------------
escelinen's Profile: http://www.excelforum.com/member.php...o&userid=27966
View this thread: http://www.excelforum.com/showthread...hreadid=502790


escelinen

Excel query via ODBC cuts values
 

Informix ODBC driver update from 2.70 to 2.81 :)


--
escelinen
------------------------------------------------------------------------
escelinen's Profile: http://www.excelforum.com/member.php...o&userid=27966
View this thread: http://www.excelforum.com/showthread...hreadid=502790



All times are GMT +1. The time now is 01:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com