How to Retrieve a Table from Access into Excel Using DAO [mskb]

[office politics]

I had to pull some data out of a access database and feed it into a excel sheet. This MS KB made this task very easy.

i had to catch myself on thsi portion of text

To use DAO in your macro, you must reference the Microsoft DAO Object Library or you may receive the error "User-defined type not defined". To reference this library in Microsoft Excel version 7.0, activate a module sheet, click References on the Tools menu, and check the "Microsoft DAO 3.0 Object Library" option. To reference this library in Microsoft Excel version 97, click References on the Tools menu in the Visual Basic Editor and check the "Microsoft DAO 3.5 Object Library".

How to Retrieve a Table from Access into Excel Using DAO