Vincent Verswijvel Posted September 7, 2020 Share Posted September 7, 2020 Hi all I wanted to create an multiple tables export to an excel file when I stumbled upon following error: So, naturally, I performed a database integrity check and every datatype was verified except the 'Production' as you can see below. Now I'm left with the question on how to solve this problem. Has anyone else encountered this problem before? Kind regards Vincent Verswijvel Link to comment Share on other sites More sharing options...
Vincent Verswijvel Posted September 8, 2020 Author Share Posted September 8, 2020 Hi Tom The email is on its way. Thank you for looking into this. Regards Vincent Link to comment Share on other sites More sharing options...
Paul Crossett Posted September 8, 2020 Share Posted September 8, 2020 The issue that was causing this error was that there were boreholes that had dates listed as pre-1900. This is not an issue within RockWorks, but when exporting out to Excel you will receive the OLE error message as Excel's dating options technically do not start until 1/1/1900. Excel will halt the export as it views those dates being exported out pre-1900 as "negative dates." If the dates are updated to show after 1/1/1900 then the export should go through without issues. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now