• This is some sample Data

    APS06 C5_LAKE_WE85912_003_8591200305PB DON 03/03/201013:41:48 Engine_Insert 10063Wed Mar 03 13:53:49 2010 20 0 0

    APS06 C5_LAKE_WE85912_003_8591200305PB DON 03/03/201013:41:48 West_Cutter_FBC_Lake 10086Wed Mar 03 13:55:31 2010 30 340 0

    APS06 C5_LAKE_WE85912_003_8591200305PB DON 03/03/201013:41:48 West_Cutter 10295Wed Mar 03 14:01:49 2010 31 119 0

    APS06 C5_LAKE_WE85912_003_8591200305PB DON 03/03/201014:07:26 West_Cutter 10295Wed Mar 03 14:07:46 2010 30 1 0

    APS06 C5_LAKE_WE85912_003_8591200305PB DON 03/03/201014:07:26 West_Cutter 10295Wed Mar 03 14:08:25 2010 30 24 0

    APS06 C5_LAKE_WE85912_003_8591200305PB DON 03/03/201014:07:26 West_Cutter 10295Wed Mar 03 14:09:23 2010 34 67 0

    APS06 C5_LAKE_WE85912_003_8591200305PB DON 03/03/201014:07:26 Engine 10163Wed Mar 03 14:11:10 2010 4 0 0

    APS06 C5_LAKE_WE85912_003_8591200305PB DON 03/03/201014:07:26 Engine 10052Wed Mar 03 14:11:18 2010 30 12 0

    APS06 C5_LAKE_WE85912_003_8591200305PB DON 03/03/201014:07:26 West_Cutter 10295Wed Mar 03 14:12:08 2010 10 0 0

    APS06 C5_LAKE_WE85912_003_8591200305ENGINEER 03/03/201014:45:40 Engine_Insert 10063Wed Mar 03 14:46:08 2010 13 0 0

    APS06 C5_LAKE_WE85912_003_8591200305ENGINEER 03/03/201014:45:40 West_DualFim_Dual_Left 10063Wed Mar 03 14:46:38 2010 10 0 0

    APS06 C5_LAKE_WE85912_003_8591200305ENGINEER 03/03/201014:45:40 West_Cutter 10298Wed Mar 03 14:47:03 2010 30 46 0

    APS06 C5_LAKE_WE85912_003_8591200305ENGINEER 03/03/201014:45:40 Mailpiece Manager 10012Wed Mar 03 14:48:50 2010 30 422 1

    APS06 C5_LAKE_WE85912_003_8591200305ENGINEER 03/03/201014:56:30 Mailpiece Manager 10012Wed Mar 03 14:56:35 2010 30 43 0

    APS06 C5_LAKE_WE85912_003_8591200305ENGINEER 03/03/201014:56:30 West_Cutter_FBC_Lake 10004Wed Mar 03 14:58:01 2010 30 173 1

    So if I make a table all strings then import this into that table using the bcp command, can I then move what I need another table and convert the data to required formats on the way?