Results 1 to 2 of 2
  1. #1
    nkpriya is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    3

    MS Access and MS Excel Data conenction

    I have access 2007 database on my system in c: drive. I am doing some queries in this access db and then from MS Excel - I am using data connections - from microsoft query - I am trying to export ms access query data to excel. So, when I go and refresh it, it has to sync data with MS Access.



    It is working fine on my PC. I created workgroups on this db too. When I try to send this excel sheet to users, when they try to login, it is looking for database with the path on my system and then returning error. Here is the error:

    C:\testdb\db.mdb is not a valid path. Make sure that the path name is spelled correctly and that you are conencted to the server on which the file resides.

    Thanks

  2. #2
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    209

    MS Access and MS Excel Data conenction

    1. Install the database on the common location for the Users on the Network Drive.
    2. Create the MSQuery Link to Excel from Access database from this location using UNC type Server location address like \\ServerName\FolderName\db.mdb rather than c:\testdb\db.mdb.
    3. Make sure that the Workgroup Information File (.mdw) installed on this common location and ask the User's to Join this workgroup from their PC by running the Workgroup Administrator.
    4. Now, send the Worksheets to the Users.

    Ref.: MS-Access Live Data in Excel

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

Similar Threads

  1. Changing data in excel from access
    By ricardo9211 in forum Import/Export Data
    Replies: 1
    Last Post: 08-26-2009, 01:46 AM
  2. Submitting data from excel to access
    By SilverSN95 in forum Import/Export Data
    Replies: 0
    Last Post: 07-06-2009, 08:19 AM
  3. iMPORTING DATA FROM EXCEL TO ACCESS
    By Rameez in forum Import/Export Data
    Replies: 7
    Last Post: 06-16-2009, 12:05 PM
  4. Replies: 1
    Last Post: 02-10-2009, 09:57 PM
  5. Call Excel Data into Access table
    By jiguvaidya in forum Import/Export Data
    Replies: 0
    Last Post: 09-15-2008, 04:58 AM

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