Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
escelinen
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
escelinen
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to put a parameter into an Excel Query Richard Excel Discussion (Misc queries) 1 January 6th 06 01:41 PM
Import query from access to excel, link to template, email on jwr Links and Linking in Excel 11 October 15th 05 05:25 PM
Error message in Excel after exporting Access query to Excel Romi Excel Discussion (Misc queries) 0 June 6th 05 02:53 PM
Missing values in Excel Line Chart mw55309 Charts and Charting in Excel 1 January 19th 05 12:10 PM
New web query with Excel Pro Edition 2003 Chandler Links and Linking in Excel 2 December 15th 04 06:03 PM


All times are GMT +1. The time now is 06:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"