Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2015
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked table from Access to Excel. Not all data updated.

    Hi, I am sorry, if the question was already asked before.

    I have a linked table in Excel from Access. I can see all my data there, but in one column I see the same result for all rows, while in Access results are different.

    I tried to avoid the problem by creating and linking to new query in Access, where the data will be just pulled from another queries. Did not help at all.

    I have to linked tables with the same problem, in the first one, the data I want to see is a number, in the second one it is text. But in both cases it was initially calculated in Access.

    Do you know how to fix it? Thank you!

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Can you be more explicit about how you linked the Access table into Excel, and can you also describe in general terms what you want to do with the data once you have it in Excel? The most common method for getting Access data in Excel is to export the data from Access to Excel. The problem with linking Access data to Excel is that a conversion to Excel data formats has to occur, and also that the data may change in Access since it is multi-user.
    Wendell

Tags for this Thread

Posting Permissions

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