+ Reply to Thread
Results 1 to 2 of 2

need to update querries to link to a new excel file which replaces previous one.

  1. #1
    Registered User
    Join Date
    09-19-2020
    Location
    USA
    MS-Off Ver
    office 365
    Posts
    1

    need to update querries to link to a new excel file which replaces previous one.

    So I have to download the current version of our inventory from an external website which prevents me from just making a linked table that updates as we update the excel file. My goal is to create an import script which will take the new file, replace the old file and still maintain all the query links. they should be mostly identical but there will be some difference in quantity data or total items if we got a new product in.

    as it stands i have been just remaking querries every week as i update the current downloaded version of inventory.

    anyone have suggestions for how to update this process to be more automatic?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,532

    Re: need to update querries to link to a new excel file which replaces previous one.

    Have you considered using Get and Transform/Power Query to query your web site data. Once downloaded, use this excel file as linked to your Access DB. Then you can run any query you wish within Access as the file is now linked. Each time you click on Refresh All in Excel, it will update and concurrently update the Access DB.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Data Link - Excel Keep asking for file to update valves
    By Reggie Wells in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-14-2017, 01:44 PM
  2. Replies: 9
    Last Post: 06-26-2014, 11:59 AM
  3. How to update automatically to xml file which is link to excel
    By clairechanmyae in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2013, 05:37 AM
  4. Replies: 3
    Last Post: 03-26-2013, 05:28 PM
  5. Link .txt file for excel to update changes
    By lorne17 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-29-2009, 11:07 AM
  6. [SOLVED] How to bypass Update link dialog when open an excel file from vb
    By chin_yen83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2005, 12:10 AM
  7. [SOLVED] Pasted text from Excel to Word replaces previous paragraph
    By TT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2005, 03:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1