select a, b into fromualid_temp
from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=d:/formualid_trans.xls',sheet1$)
excel txt 导入 sql
最新推荐文章于 2024-07-20 16:40:31 发布
select a, b into fromualid_temp
from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=d:/formualid_trans.xls',sheet1$)