MSQuery>XL Sheet Truncated to 15 Chars

  • Thread starter Thread starter Ivan Booth
  • Start date Start date
I

Ivan Booth

Data that displays as 30 chars in MSQuery is truncated to
15 chars when sent to XL.
Office 2000
Data Source ODBC informix 3.8 Unix platform.
 
Hi Ivan,

Does the same problem happen if you query on a new, simple, test table
in your Informix database?

If so, I would suggest narrowing down whether it is a problem with the
ODBC driver:

a) Does the same problem happen with other drivers, such as the Excel,
text, or Access drivers, when querying on a simple test table?

b) Does the same problem happen when clients other than Excel use the
same ODBC driver?

If after those tests it looks like a problem with the ODBC driver, is
the vendor of the driver aware of the problem? (I don't think MS has
ever shipped an Informix driver.) Also, you might want to ask on
comp.databases.informix too.


Good luck,

Greg Lovern
http://PrecisionCalc.com
Get Your Numbers Right
 
Back
Top