When I export to Excel, the date/time format is not recognized.

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.

1. In BCP, select Export from File menu, select Custom from pop-up menu
2. Click 'Preferences' and:
   1. Associated Products: 

      BCP4.3-ON

      BHW-LITE

      BHW-MAC

      BHW-PC

      BHW-T-ALRM