Results 1 to 2 of 2
  1. #1
    BobW2961 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    16

    Import data to excel from an access database on the network

    I can easily create an excel document that imports data from my access database.
    In excel, when make the connection i point to the database using the network address of the database. for example, rather than just giving the local path for the access database, I give it a path using the local computer name. \\mr01monitoring\plant monitor\plant monitor.accdb

    This works fine. I can open the excel file and the data imports correctly.


    However, I create a shortcut to the excel file from another computer on the network and when I open the file from another computer, it is not able to connect to the access database.

    If I try to create a new excel file on a network computer and point the connection to the access file that is on another network computer, it tells me there are no visible tables"

    I have made this work before, but cant remember what had to be done. I believe that maybe the connection type was something other than "MS Access"

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    does everyone have rights to the PC with \\mr01monitoring\plant monitor\plant monitor.accdb
    the excel should use this path imbedded in the Connection string, NOT the shortcut

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import data from excel to Access Database
    By n2d2cool in forum Access
    Replies: 1
    Last Post: 12-13-2016, 05:02 AM
  2. Replies: 1
    Last Post: 07-24-2015, 07:06 AM
  3. Replies: 2
    Last Post: 06-25-2015, 03:56 PM
  4. Auto Import Excel Data into a Running Access Database
    By novice1979 in forum Programming
    Replies: 5
    Last Post: 12-02-2014, 08:19 AM
  5. Import access query data into excel file, using excel vba
    By exceljockey in forum Import/Export Data
    Replies: 3
    Last Post: 11-15-2013, 02:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums