PDA

View Full Version : Access query to populate Excel spreadsheet



jludt
09-14-2010, 07:37 AM
I need some expert assistance on this one. If there is any easier way to accomplish what I am about to explain I would love to hear alternative methods as well.

I am trying to populate a spreadsheet which has predetermined headings through a query from access. Aside from the query (which I have yet to formulate) being rather complicated I just want to know if I am even going about this in the correct manner and if so how can I pull a simple access query into excel?

HiTechCoach
09-15-2010, 11:25 AM
I would probably use automation to do it.

You might be able to9 use something as simple a .CopyFromRecordSet

Also see:
Export Data To Excel

(http://www.vbaexpress.com/forum/)