tony28 (1/25/2013)
INSERT INTO [dbo].[TB_WORK_ORDER_AGVEN]([ORDER_DATE]
,[COMMIT_NO]
,[BODY_NO]
,[STATION_ID]
,[DATA_TYPE]
,[CAR_CODE]
,[WO_SERIALNO]
,[EXT_COLOR]
,[INT_COLOR]
,[FSC_TDATA]
,[BODY_TYPE]
,[DRIVE_TYPE]
,[TRIM_LEVEL]
,[REPORT_DTIME]
,[RCV_TRID]
,[ERP_RCV_IFTIME]
,[PRT_BC_FLAG]
,[PRT_BC_TIME]
,[PRT_TROL_FLAG]
,[PRT_FEED_FLAG]
,[LOAD_FLAG]
,[LOAD_TIME]
,[INSP_FLAG]
,[PROD_FLAG]
,[PROD_SDATE]
,[PROD_ATIME]
,[ERP_PROD_IFTIME]
,[SHIP_FLAG]
,[SHIP_SDATE]
,[SHIP_ATIME]
,[ERP_SHIP_IFTIME]
,[ERP_SD_IFTIME]
,[ERP_DEL_IFTIME]
,[ORDER_DESC])
VALUES
(<ORDER_DATE, char(8),>
,<COMMIT_NO, char(4),>
,<BODY_NO, varchar(12),>
,<STATION_ID, char(4),>
,<DATA_TYPE, char(2),>
,<CAR_CODE, varchar(3),>
,<WO_SERIALNO, varchar(15),>
,<EXT_COLOR, char(3),>
,<INT_COLOR, char(3),>
,<FSC_TDATA, char(29),>
,<BODY_TYPE, char(10),>
,<DRIVE_TYPE, char(6),>
,<TRIM_LEVEL, char(10),>
,<REPORT_DTIME, varchar(14),>
,<RCV_TRID, numeric(10,0),>
,<ERP_RCV_IFTIME, varchar(14),>
,<PRT_BC_FLAG, char(1),>
,<PRT_BC_TIME, varchar(14),>
,<PRT_TROL_FLAG, char(1),>
,<PRT_FEED_FLAG, char(1),>
,<LOAD_FLAG, char(1),>
,<LOAD_TIME, varchar(14),>
,<INSP_FLAG, char(1),>
,<PROD_FLAG, char(1),>
,<PROD_SDATE, char(8),>
,<PROD_ATIME, varchar(14),>
,<ERP_PROD_IFTIME, varchar(14),>
,<SHIP_FLAG, char(1),>
,<SHIP_SDATE, char(8),>
,<SHIP_ATIME, varchar(14),>
,<ERP_SHIP_IFTIME, varchar(14),>
,<ERP_SD_IFTIME, varchar(14),>
,<ERP_DEL_IFTIME, varchar(14),>
,<ORDER_DESC, varchar(30),>)
GO
With the data from the excel sheet.
It should be many lines of INSERT statements
INSERT INTO table VALUE ('20120101','29443','354643',abcd.........................) etc etc etc for all tables