I'm trying to create reports in Excel using the Advantage ODBC driver (we are using CommitCRM SQL). I can link all the tables I require except the most essential one - the SLIPS table. Whenever I try to link this table to any of the others (for example, the CARDS table), the following error is returned.
We couldn't get data from the data model. Here's the error message we got:
An error occurred while parsing the 'R' element at line 598, column 72 ('urn:schemas-microsoft-com:xml-analysis:rowset' namespace) under Envelope/Body/Execute/Parameters/Value/row/(any). The '-' string cannot be converted to the long type.
Are you able to assist me in how I might clean this data up to enable linking.
We couldn't get data from the data model. Here's the error message we got:
An error occurred while parsing the 'R' element at line 598, column 72 ('urn:schemas-microsoft-com:xml-analysis:rowset' namespace) under Envelope/Body/Execute/Parameters/Value/row/(any). The '-' string cannot be converted to the long type.
Are you able to assist me in how I might clean this data up to enable linking.
Comment