I am creating excel driven ODBC SQL reports on a Sybase 16 database and some of the numeric fields have precision too high for the Excel ODBC driver. I am not at all concerned with precision loss - I am happy with <15 decimals.
Without handling Excel is simple crashing upon the rs.Open cSQL, oCon call. The only solution I have is to code the SQL with a convert(numeric(30,15),Field) on every numeric output field which is less than ideal.
Is there a simple solution to apply this at a connection or database behavior level short of changing the fields in the DB themselves (which is not an option)?
Thank you!
baltman
Without handling Excel is simple crashing upon the rs.Open cSQL, oCon call. The only solution I have is to code the SQL with a convert(numeric(30,15),Field) on every numeric output field which is less than ideal.
Is there a simple solution to apply this at a connection or database behavior level short of changing the fields in the DB themselves (which is not an option)?
Thank you!
baltman
