I export a table to excel file by using DTS. It seems the date field show as ###### when I open the excel file. If I expend the column I see the date. Is there any way I export in away that this date field will not show up as #####.
I may be wrong, but I would think that this is a function of Excel itself -|||I agree with David, it should be a display issue of Excel. You can expand all folded columns: go to Format Menu in Excel->Column->click AutoFit Selection.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment