insert into SYNC_BEE
(
APPLICATION_NO,
OFFICE_NAME,
PROJECT_NAME,
PRODUCT_TYPE,
MODEL,
QTY,
PRICE,
PUNISH_MONEY,
ECC_SUPPORT_DIS,
ECC_SUPPORT_DEALER,
DISTRIBUTOR_NAME,
DEALER_CODE,
DEALER_FULL_NAME,
YEAR_DATE,
CREATEDATE,
LOCK,
CREATEBY,
UPDATEDATE,
UPDATEBY,
OUTDATE,
OFFICE_CODE,
APPLICATION_CREATER
)
select
APPLICATION_NO,
OFFICE_NAME,
PROJECT_NAME,
PRODUCT_TYPE,
MODEL,
QTY,
PRICE,
PUNISH_MONEY,
ECC_SUPPORT_DIS,
ECC_SUPPORT_DEALER,
DISTRIBUTOR_NAME,
DEALER_CODE,
DEALER_FULL_NAME,
YEAR_DATE,
CREATEDATE,
LOCK,
CREATEBY,
UPDATEDATE,
UPDATEBY,
OUTDATE,
OFFICE_CODE,
APPLICATION_CREATER
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source=E:\copy\BudgetQuery.xls;Extended properties=Excel 5.0')...[BudgetQuery$];