Set db = New Connection
db.Open “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ASHOK\D$\VB PROJECT\DATA\A.mdb;Persist Security Info=False”
Set XL = New Recordset
XL.Open “DATA0607”, db, adOpenStatic, adLockOptimistic
*/////
BUT I WANT TO USE
XL.OPEN “SELECT * FROM DATA0607 WHERE MONTH=”+MT+” OR MONTH = “+MT1+”,DB, ADOPENSTATIC
BUT THE ABOVE SYNTEX IS NOT WORKING
