Consulting

Results 1 to 2 of 2

Thread: Access query to populate Excel spreadsheet

  1. #1

    Access query to populate Excel spreadsheet

    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?

  2. #2
    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

    Boyd Trimmell aka HiTechCoach
    Microsoft Access MVP -2010-2015

    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •