Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Precison too large error via Excel/ODBC solution needed

Status
Not open for further replies.

baltman

Technical User
Mar 5, 2002
1,578
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top