Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Updating Excel info through Access

  1. #1
    Guest

    Default

    I am trying to create an interface in MS Access to easily update an Excel spreadsheet. The spreadsheet is already linked to the Access database. However, any updates that are made in the Access database, result in what I guess is data coruption as the Excel file will no longer open. Any suggestions are greatly appreciated.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    You'll need to provide a few more details. How exactly is the Access database updating your Excel workbook? Is this 'on-line' or at a certain interval. VBA or not? If so, can you provide code, if not, can you provide details of the link between Excel and Access?

    Regards,
    D

  3. #3
    Guest

    Default

    The database and the spreadsheet are both on a network drive. The spreadsheet was originally created in Excel and then Linked to Access for ease of reporting. No additional code was created. The spreadsheet was simply linked to Access using the link spreadsheet wizard.

  4. #4
    Guest

    Default

    Also, the data in Excel is periodically udated manually. When the link in Access is opened, the new data is refreshed in the Access database automatically by viewing the linked Excel file. Any data manipulation in the database is not carried back to the spreadsheet however.

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
  •