Copying values and pasting in exl using macro

Closed
karthick - Mar 16, 2010 at 11:40 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 17, 2010 at 10:52 AM
Hello,
I need to copy all the values in the "Table"menus inside the Ms access (database) and paste in the particular sheet of my excel 2007 . How i need to write a coding using macros? Or what are the steps to follow.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 17, 2010 at 10:52 AM
you have to open connection to database in excel and then establish a record set and then loop thru the set