09-03-2020 12:39 AM
when I attach a XLS file, GeoMedia interprets a specific column as format double. But in fact this is a parcel number column, containing data like 111 and 111/1. The second value will be skipped by GeoMedia.
I tried to format the excel sheet to text or added text in the first data line, no success. I tried to use formatattribute, but the missing data stay missing.
How can I force GeoMedia to read this excel column as text?
09-03-2020 04:43 AM
I can't answer your question, but I do want to mention, in case you have the opportunity to use later software, that GeoMedia 2020 has introduced a new Excel data server that is vastly superior to the old Access "attach" mechanism and its use of Microsoft ISAM driver technology. You can even drag-and-drop an XLSX into your GeoWorkspace to connect to it. - Hal