Results 1 to 2 of 2
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Thumbs up

    I have built an Excel template file and a query in Access. I want to export the data from Access to named fields in the Excel file.

    There will never be more than one row of data from Access (it is very specific).

    I need some code to get started.
    Alan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can use Automation to control Excel from Access using VBA. See WendellB's tutorial Automation 101 for an introduction and useful links.

    You can search this forum for "excel.application" (including the quotes) to find previous topics about automating Excel.

Posting Permissions

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