Post reply

SQL 2K to Excel - Date field won't return time

  • June 18, 2008 at 9:31 am

    #122818

    I am exporting data from SQL 2000 to Excel (Office 2003). One of my fields contains date and time. The date comes across fine but it doesn't bring the time part of the field.

    Any nudges in the right direction would be greatly appreciated!

    Thanks,

    Bob

  • June 18, 2008 at 1:10 pm

    #830714

    In Excel, highlight your column, select data then text-to-columns. This fixed an issue I had trying to convert what Excel thought was a text field back to a date-time field. Here's a great little forum for all sorts of Excel related topics:

    http://www.ozgrid.com/forum/

    -- You can't be late until you show up.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply