Results 1 to 4 of 4

Possible to access... Access database table if file name changes (fixed prefix)?

Threaded View

  1. #1
    Registered User
    Join Date
    05-08-2017
    Location
    Toronto
    MS-Off Ver
    MS365 Version 2404
    Posts
    87

    Possible to access... Access database table if file name changes (fixed prefix)?

    Hi all,

    I tried looking online but couldn't find anything on this. Basically, I have an Excel spreadsheet where I pulled data from an Access database using the "From Access" button and following the instructions. The database was imported successfully, I added the macros that were needed in the spreadsheet, and making changes in the .accdb data and refreshing works fine too. H

    However, it seems the accdb file's name is supposed to change, which means connectivity cannot be maintained. The accdb file's name format is simply "Stuff Access Database [Month] [Day]", for example "Stuff Access Database March 23". Is there a way to maintain the connectivity by, say, checking only if the file has "Stuff Access Database" as a prefix, rather than the whole name? No other file in the directory has this same prefix. I understand this is a long shot, but thought I'd try asking any way.

    Thanks!
    Last edited by noname91; 04-08-2020 at 05:28 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. List of Access database paths in Excel - Need to return Access version
    By Wedge120 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2019, 12:19 PM
  2. copy data from one access database to another access database
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2014, 09:03 AM
  3. Use an Excel Macro in Access VBA - Import text file in Access Table
    By joogibabu in forum Access Tables & Databases
    Replies: 3
    Last Post: 10-08-2014, 10:04 AM
  4. Replies: 2
    Last Post: 07-05-2013, 09:37 AM
  5. How To run Access database without having to install Access on user PC's
    By Reema in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2009, 04:02 AM
  6. combining multiple access tables in Access Database
    By Reema in forum Access Tables & Databases
    Replies: 3
    Last Post: 03-25-2009, 12:10 AM
  7. importing data from access-database access file
    By amrezzat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2005, 04:25 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