SQL to Excel Import

I have a table in SQL 2008 R2 called Inspection.
a column in that table called date formated as date with allow nulls

Every time I import this into excel the column comes over as text instead of date.  I have to select the column and select "Text to columns" so this data will show up as date.

How can I fix this??
Curtis LongAsked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
The column has to formatted as DateTime, not DateTime2. Excel doesn't recognize dates in the DateTime2 format.

Kevin
0
 
Curtis LongAuthor Commented:
You are my HERO!!

If I could give you 1,000 points I would!!  :-)
0
 
zorvek (Kevin Jones)ConsultantCommented:
:-)
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.

All Courses

From novice to tech pro — start learning today.