/ All posts
- Problems importing MDB into Manfifold 8 (32 bit)
I am having trouble importing the attached MDB file in M8-32bit version. I was able to do this before - maybe 2 years ago but the format of the MDB may have been updated by the software that creates it. It is not Access, but a specialized survey calculation software built on the "Intellicad" cad engine. I am able to open the file with LibreOffice where I see that it contains a single table. (See compiled screen captures in PDF attached) When opening it, I am prompted to select a "Character Set", and after some trials discovered that "Western Europe (ASCII/US)" gives the best results.
The attached sample MDB is just one of 100's that I need to import and the process needs to be repeated on a regular basis so a manual conversion process for each file is not a practical solution.
I notice the release notes of the newest Radian version mentions something about improved performance with database files, but to be honest I got scared by the entirely new UI so have not used it.
Perhaps it is time?
Data view in LibreOffice.pdf
I viewed your LibreOffice.pdf file.
I see there are several "," in the field naming on top of each column.
I am not aware that "," are allowed in field naming.
Alas, I have found the offending code and looked at the coder who made the gaff... and saw myself looking back in the mirror.