Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2004
    Location
    Asheville, North Carolina, USA
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access -> Excel (Access/Excel 97)

    Not sure if this needs to go here or on the Excel Forum. I have 8 queries that gives me a count by mouth for 8 individuals. I want to link this info to a Excel worksheet. The common area will be the months. I hope this is enough info to get started.
    Thanks for any assistance.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access -> Excel (Access/Excel 97)

    Do you want to have a link to an Excel worksheet in the Access database, or do you want a link to the Access queries in the Excel worksheet?

  3. #3
    Star Lounger
    Join Date
    May 2004
    Location
    Asheville, North Carolina, USA
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access -> Excel (Access/Excel 97)

    Sorry, link the Access queries in the Excel worksheet.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access -> Excel (Access/Excel 97)

    You can use Data | Get External Data | Create New Query... to import Access data into your Excel worksheet. The link won't be live, but you can update the data by clicking the Refresh Data button on the Data toolbar, or by selecting Data | Refresh Data.

Posting Permissions

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