想实现一个功能 在电脑上没有装office的情况下，将access中数据添加到excel表格中，或将excel中数据添加到access中，想以ado的方式实现，把xls文件当作数据库处理。目前将access导入到excel中成功了
"select tele_code as 号码,username as 姓名,department as 单位,address as 地址,re as 备注 into [excel 8.0;database=" & App.Path & "\book.xls].号码 from tele"但是excel导入到access却失败了 不知道是什么原因？"select 姓名 as USER,单位 as DEPARTMENT,代码 as CODE,号码1 as TELE_CODE into [tele] from [excel 8.0;database=" & LocalPath & "].[tele$]"
Excelaccessado
"select tele_code as 号码,username as 姓名,department as 单位,address as 地址,re as 备注 into [excel 8.0;database=" & App.Path & "\book.xls].号码 from tele"但是excel导入到access却失败了 不知道是什么原因？"select 姓名 as USER,单位 as DEPARTMENT,代码 as CODE,号码1 as TELE_CODE into [tele] from [excel 8.0;database=" & LocalPath & "].[tele$]"
Excelaccessado
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货