Access 2007 Use VBA

Question

I have data in access in the form of a table. I need to export it to excel in the form of an excel sheet where i should even be able to make updates to the data if necessary. I have to do this using VBA. And also one more thing the data I have in access is which i have generated using SQL

Answer 1

Why do this with VBA? There are multiple simple ways to do this from the normal interface options.

And what do you mean by, "the data I have in access is which i have generated using SQL"?

Answer 2

Modules: Sample Excel Automation - cell by cell which is slow

Modules: Transferring Records to Excel with Automation