Thread moved from CodeBank forum (which is for you to post your code examples, not questions)

To get the data from Access, use ADO code as shown in the "Classic VB: ADO" section of our Database Development FAQs/Tutorials (at the top of the Database Development forum)

To put it into Excel, see my Excel Tutorial (link in my signature), particularly the CopyFromRecordset part.