[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


excel (obdc to sql 2000) data type error

Posted on 2011-05-13
Medium Priority
Last Modified: 2012-08-13
We open lots of sql 2000 views using excel 2003 office on our network. However on a couple of users they get the error

The conversion of a char datatype to a datetime data type resulted in an out of range value

they strange thing is on this specific user I logged in as admin and it returned the query in excel but then logged in as the user and got the above error!!!! didnt expect that.

I've just tried to open the spreadsheet on my laptop as well and excel installed the odbc driver and I get the error too.
Question by:Chris Michalczuk
  • 2
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 35752405
Could it be the regional settings. Maybe for the user logged in, but possible also on the connection to SQL server.
LVL 10

Expert Comment

ID: 35753383

Accepted Solution

Chris Michalczuk earned 0 total points
ID: 36055960
closed as no answer given

Author Closing Comment

by:Chris Michalczuk
ID: 36119896
the answers given were not helpful

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question