By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,490 Members | 1,489 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,490 IT Pros & Developers. It's quick & easy.

error in transfering data into excel

P: 40
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.openrecordset (squery) // INVALID OPERATION

is there any way to transfer this output into excelsheet after this query

pleassssssss help

thanks in advance
Apr 11 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.