Results 1 to 6 of 6
  1. #1
    JEEVAN34 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    10

    Link an excel sheet to access database.

    Hello,

    I have exported an Excel sheet from Access database, which i created usesd a query. Now, i want to link this Excel sheet to Access database so that, whenever some changes are made in database it gets automatically updated in the Excel sheet. Please, let me know if there is way to do this.

    Thanks in advance

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You can't have it linked AND export to it.
    Theres no point to link it into the db. If you export the data,then all the data is up to date.

  3. #3
    JEEVAN34 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    10
    Quote Originally Posted by ranman256 View Post
    You can't have it linked AND export to it.
    Theres no point to link it into the db. If you export the data,then all the data is up to date.
    What if any changes are made to the data in database?

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    as far as I know it's possible to use an access data source within an excel spreadsheet, you should be able to link your query into an excel spreadsheet so that it's always current.

  5. #5
    JEEVAN34 is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    10
    Quote Originally Posted by rpeare View Post
    as far as I know it's possible to use an access data source within an excel spreadsheet, you should be able to link your query into an excel spreadsheet so that it's always current.
    Thanks .. I too read it somewhere..but couldn't steps about how to do it?

    Can you please guide how to do it?

    or any links to that steps?

  6. #6
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442

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

Similar Threads

  1. Replies: 13
    Last Post: 02-24-2016, 02:33 PM
  2. Replies: 1
    Last Post: 04-01-2014, 04:18 AM
  3. How to I update access with an excel sheet?
    By superfly5203 in forum Access
    Replies: 5
    Last Post: 01-24-2013, 10:52 AM
  4. Replies: 26
    Last Post: 01-08-2013, 04:55 PM
  5. Replies: 2
    Last Post: 12-26-2012, 02:58 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