excel (obdc to sql 2000) data type error

Posted on 2011-05-13
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:chrismichalczuk
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    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


    Accepted Solution

    closed as no answer given

    Author Closing Comment

    the answers given were not helpful

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now