I tried running my data query in excel and in idea.Neither are correct - Any thoughts on what I am seeing. I was hoping with only 4 fields that either Idea or Excel could import the data correctly, but no luck.Thanks!
Excel
Comment = text = correct
Comment id = column is missing = wrong
Created by = alphanumeric = correct
Reg note id = column is missing = wrong
Idea
Comment = numeric (character) = wrong
Comment ID = hexadecimal (character)= wrong
Created by = alphanumeric (character)= correct
Reg note id = hexadecimal (character) = wrong
*note when I view this in Microsoft query all looks fine , but the view cannot be copied or saved and when it renders to excel is incorrect as above.
lbrinkmann
Offline
Last seen: 7 years 11 months ago
Joined: 09/21/2015 - 08:53
Hello and welcome to the site. Unfortunately I haven't used ODBC drivers that much to be in a position to help you out. Hopefully someone else might be able to help or I would recommend you contact your IDEA distributor as they would hopefully be in a better position to help.
Brian