• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

excel (obdc to sql 2000) data type error

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.
0
Chris Michalczuk
Asked:
Chris Michalczuk
  • 2
1 Solution
 
Nico BontenbalCommented:
Could it be the regional settings. Maybe for the user logged in, but possible also on the connection to SQL server.
0
 
borgunitCommented:
0
 
Chris MichalczukConsultantAuthor Commented:
closed as no answer given
0
 
Chris MichalczukConsultantAuthor Commented:
the answers given were not helpful
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now