When I export to Excel, the date/time format is not recognized.
When I export to Excel, the date/time format is not recognized.
faqid:
196
Following is a method of exporting the data that will fix this problem in addition to stripping the milliseconds and separating the date and time into two columns.
- In BCP, select Export from File menu, select Custom from pop-up menu
- Click 'Preferences' and:
Associated Products:



