Anyone have this happen: I am successfully extracting data from a SQL database application called Tigerpaw using the universal connector. The problem is the data is not being recognized as a numeric value in Excel and I cannot change it using the cell formatting function. The Tigerpaw DB field is set-up as a currency value, so I can't figure out why Jet is extracting it ok with my formula, but not recognizing the resulting data as numerical.
Anyone ever experience this?
Thanks,
Ben
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Ben,
When you say a "SQL database application", what is the actual database back end? Is it Microsoft SQL Server or is it something proprietary to Tigerpaw? If you open the Browser and then select the table and select the field, you can expand the Details section at the bottom of the browser, you can see the actual field type. It may just be that Tigerpaw is storing the currency data in a text type field or it may depend on the database driver itself. In Excel, you may be able to use the VALUE function in order to convert the value being returned by Jet into a number as well.
Regards,
Hughes -
Jet Reports Historic Posts Value function worked… thanks!
Please sign in to leave a comment.