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

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 Long
Curtis Long
  • 2
1 Solution
zorvek (Kevin Jones)ConsultantCommented:
The column has to formatted as DateTime, not DateTime2. Excel doesn't recognize dates in the DateTime2 format.

Curtis LongAuthor Commented:
You are my HERO!!

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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