MS SQL Server - Export sql query result to excel soread sheet

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Export sql query result to excel soread sheet

Catelin wang

2005-03-31, 8:01 pm

I couldn't get the field titles on the Excel and for the datetime field it
only shows time not date & time.

Thanks

Jack

2005-03-31, 8:01 pm

Check the cell format of the Excel spreadsheet to see is it set on "Date >
mm/dd/yy hh:mm" format or not

"Catelin wang" wrote:

> I couldn't get the field titles on the Excel and for the datetime field it
> only shows time not date & time.
>
> Thanks
>
>
>

Sponsored Links