(1)excel 2000 ,用ADO打开。private Const Provider = "Microsoft.Jet.OLEDB.4.0"
private Const ExtendedProperties = "Excel 8.0" DBCn_xls.Provider = Provider
DBCn_xls.Properties("Extended Properties") = ExtendedProperties
DBCn_xls.Properties("Data Source") = sSaveAsFile
DBCn_xls.Open
Set DBRs_xls = DBCn_xls.Execute("Select * from `sheet1` ")然后应该知道怎么办了吧。
private Const ExtendedProperties = "Excel 8.0" DBCn_xls.Provider = Provider
DBCn_xls.Properties("Extended Properties") = ExtendedProperties
DBCn_xls.Properties("Data Source") = sSaveAsFile
DBCn_xls.Open
Set DBRs_xls = DBCn_xls.Execute("Select * from `sheet1` ")然后应该知道怎么办了吧。
Run-time error '3343':Unrecognized database format 'D:\XXX\aaa.mdb'如何解决呢?
我Win98的机子上是VB6+Office XP,而另一台机子是Win2K AD +VB6+Office 2000
我知道office 97 用jet3.51 excel 7.0
office 2k 用jet4.0 excel 8.0
xp你看看.