How to Extract Data from Access into Excel?

[sxmo]

I have a project currently need some vba code that can extract Data from Access into Excel.

Does anyone know how to do it?

Thank you!

 

[SydneyGeek]

It depends what you need.
One option is to use MSQuery (the External Data option in Excel) to pull in the contents of a table or query. No code required.
Another is to use ADO code. There are plenty of examples on this site, and a tutorial here: Part 4 is the most relevant for you now but look at the rest of it too.

Denis

 

[sxmo]

Thank you, sir, that's very helpful!