Hi Everyone,
just a bit of background, we have several Excel Applications that use ODBC to fetch data from UV files and update, and have reached the limits of what is available with the allowed joins and use VBA scripts to perform several queries.
We run in to problems that if there are no Client Licences available, for obvious reason the Queries don't execute and this can lead to problems getting the queries to rerun
I am sure this is down to MS Excel / MS Query / limitations of the Rocket ODBC drivers. we are using the latest U2CL_5.2.1
I was wondering if anyone has any experience of using MS Access as a vehicle to extract data and if "LINK TABLES" are considered a supportable and reliable way to extract the External Data and then point our Excel process at the Access harvested data rather than Excel extract the data directly from UV
I've had a play and only got limited success with the MS ACCESS "Link Table", some tables wont return data and present on ODBC - CALL FAILED error, even though the same table opens in MS Query with the same ODBC driver, and other tables show "ERROR" in the fields on some of the ROWS, so not what i was hoping for
I've spent quite a bit of time reading the Rocket ODBC documentation and extensively Googled this, but can't find any real help, in fact there seems to be no mention of using MS Access to extract UV data, via ODBC but MS Excel seems to be vehicle of choice that Rocket seem to support
So if there is anyone out there who has had similar issue with MS Excel and ODBC not working as desired or if anyone can comment on the suitability of MS Access and ODBC and Linked Tables it would be good to hear your thoughts and advice, or indeed, if there are now any better tools for Extracting data directly from UV files
Many thanks
Andy
------------------------------
Andrew Milne
Business Systems Manager
Potter and Moore Innovations
------------------------------
