4D Database Export to Excel using ODBC
Posted on 2008-09-29
I am a power user/ certified external consultant of a third party developed industry specific package that is based on the 4D database engine. I'm based in Australia and the package was developed here as well. I want to enhance the standard reports provided by the package by extracting the data via ODBC to Excel. The third party developer is not willing to assist me as they see me as a competitor in terms of consulting income.
I'm an accountant, not a developer and I don't have programing skills. However, I have been around PCs a long time and am not afraid to tinker with software.
I'd love to receive your advice about:
(a) which ODBC to use,
(b) how to configure it to talk to the 4D database
(c) how to extract the data via the ODBC to Excel
Thanks in advance