Jump to content
RockWare Support Forum

Recommended Posts

Hi all

 

I wanted to create an multiple tables export to an excel file when I stumbled upon following error:

image.png.ce41ba47860a45b324b6d4d2c869bf3e.png

 

So, naturally, I performed a database integrity check and every datatype was verified except the 'Production' as you can see below. 

image.png.6d0e3b0132ec4828709edf1abb4e5337.png

 

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 post
Share on other sites

Hi Vincent,

 

Please backup your project with the File | Backup Database, and send the ZIP file to Support@rockware.com. We'll take a look to see how to resolve the problem.

 

Regards,

Tom B

RockWare Inc

Link to post
Share on other sites

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 post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...