Assume I have VBA connected to database already.
How to write VBA code (code efficient, hope not copy one record at a time) to copy the whole database table(including field names) into a excel spreadsheet?
Thanks.
Assume I have VBA connected to database already.
How to write VBA code (code efficient, hope not copy one record at a time) to copy the whole database table(including field names) into a excel spreadsheet?
Thanks.
Last edited by VAer; 01-21-2017 at 10:54 PM.
Assuming you know ADODB is how you are already connected to your database. Also assuming you have the sql
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks