Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Access to Excel

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I link an Access Database to Excel so I can calculate some statistics and then convert it back into Access again so I can create a report with those calculations? Thanks!

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nobody has any ideas?

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-21 19:18, Q45 wrote:
    Nobody has any ideas?
    I dont... But wait till monday. You'll probably get alot more people looking at your message then. (from what I can tell, most people read this board from their workplace )


  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks.

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am sure it can be done friend.The way I normally do it is,when I extract excel to access,I would put it in form view and just export it back to excel.Hope i've been of assistance to you.

  6. #6
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    From Excel, use Get External Data to get your data from Access.

    Name the range where you do the calculations for your statistics.

    In Access, link to your named range.

    Good luck

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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