insert into Invoice_AccuInfo ([cCompanyName]
,[cCompanyAddr]
,[cContact]
,[cTel]
,[cBankName]
,[cBankAddr]
,[cAccountName]
,[cAccountNumber]
,[cSwiftCode]
,[iStatus]
,[dCreateDate]
,[cCreateID]
,[dModifyDate]
,[cModifyID]
,[Filepath]
,[Currency]
,[GSJC]
,[YXJC])
select [cCompanyName]
,[cCompanyAddr]
,[cContact]
,[cTel]
,[cBankName]
,[cBankAddr]
,[cAccountName]
,[cAccountNumber]
,[cSwiftCode]
,[iStatus]
,[dCreateDate]
,[cCreateID]
,[dModifyDate]
,[cModifyID]
,[Filepath]
,[Currency]
,[GSJC]
,[YXJC]
from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=E:\abc.xls',Invoice_AccuInfo$)
,[cCompanyAddr]
,[cContact]
,[cTel]
,[cBankName]
,[cBankAddr]
,[cAccountName]
,[cAccountNumber]
,[cSwiftCode]
,[iStatus]
,[dCreateDate]
,[cCreateID]
,[dModifyDate]
,[cModifyID]
,[Filepath]
,[Currency]
,[GSJC]
,[YXJC])
select [cCompanyName]
,[cCompanyAddr]
,[cContact]
,[cTel]
,[cBankName]
,[cBankAddr]
,[cAccountName]
,[cAccountNumber]
,[cSwiftCode]
,[iStatus]
,[dCreateDate]
,[cCreateID]
,[dModifyDate]
,[cModifyID]
,[Filepath]
,[Currency]
,[GSJC]
,[YXJC]
from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=E:\abc.xls',Invoice_AccuInfo$)