Hi,
I was wondering if anyone could provide me with code to execute a macro in excel which would execute an access query and copy the results to an excel worksheet. or possibly work sheets depending on how many records there actually are.
I've got code to export to access but i need code to import access query results.
Hope there is help out there =]
Thanks in advance.
Last edited by pr4t3ek; 10-15-2008 at 06:32 AM.
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Hi
Try this.
The database is c:\temp\test.mdb
Please Login or Register to view this content.
and there is a query called qry_test1 in that database
and it will put the output to A1 of the current sheet.
If you are likely to get > 65k records from this query, is there any way you can break it down into smaller parts and bring back each part to a separate sheet? If not, then the only thing I can think of is to cycle through the records in the recordset and output each one, keeping a count of the output row and move to a new sheet, but that would take quite a while to process....
HTH
rylo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks