Hi
actually i want to confirm can i transfer this table data into excel after this query which you gave me . I mean i want to show this table data into excelsheet
i use this method but it shows error "invalid operation" on bold line
squery = " select Yp1EOp, count(*) As ECount INTO " & txtchildMDBF _
& " From " & txttablename & " GROUP BY Yp1EOp ORDER BY Yp1EOp"
set rsmaster= dbmaster.openre cordset (squery) // INVALID OPERATION
is there any way to transfer this output into excelsheet after this query
pleassssssss help
thanks in advance
actually i want to confirm can i transfer this table data into excel after this query which you gave me . I mean i want to show this table data into excelsheet
i use this method but it shows error "invalid operation" on bold line
squery = " select Yp1EOp, count(*) As ECount INTO " & txtchildMDBF _
& " From " & txttablename & " GROUP BY Yp1EOp ORDER BY Yp1EOp"
set rsmaster= dbmaster.openre cordset (squery) // INVALID OPERATION
is there any way to transfer this output into excelsheet after this query
pleassssssss help
thanks in advance