＋设为首页 ＋添加到收藏夹
现在想实现把一个EXCEL表中从第5行开始的所有记录插入到SQL库表A中去.这条SQL该怎么样写呢?请指教!
我现在是这样写的:
MyCmd.CommandText = "insert into A select * FROM OPENROWSET(MSDASQL.1, driver=Microsoft Excel Driver (*.xls);DBQ=" & FileName & ",select * from [sheet1$])"在这个基础上怎么实现取EXCEL从第5行开始的所有记录呢?
"insert into A select * FROM OPENROWSET(MSDASQL.1, driver=Microsoft Excel Driver (*.xls);DBQ=" & FileName & ",select * from [sheet1$] where 主键 not in (select top 5 主键 from [sheet1$]))"
