Results 1 to 2 of 2

Fetch Data From MS-Access

  1. #1
    kashif.special2005 is offline Novice
    Windows XP Access 2002
    Join Date
    Jan 2011

    Fetch Data From MS-Access


    I have a student database in MS-Access, And I want to fetch some part of data from ms-access to excel.There is a macro in access where 20 to 25 queries in that macro, I want to hit macro first so macro will do all the calculation in ms-access, then at end final query will store result data in "Student_Final_Result" table, After that I want to fetch all data from "Student_Final_Result" to excel in Sheet("Student").range("a1"), But I am not sure how will I do this.....

    Database Name Student_Data.mdb
    Macro_Name Stu_Calc

    Temprary_Table Student_Final_Result
    Excel_Workbook Student Result
    Result_Sheet Student
    Paste_Range Sheet("Student").range("a1")

    Please help me to resolve this problem.

    Thanks & Regards,

  2. #2
    apr pillai's Avatar
    apr pillai is offline Contributor
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Alappuzha, India
    You can bring the data from an access table/query values into Excel and keep the data refreshed every time change happens in access without writing VBA Code.

    The Reference link: Access Live Data in Excel.

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

Similar Threads

  1. How to fetch latest records from table
    By India62 in forum Access
    Replies: 13
    Last Post: 05-19-2011, 11:43 PM
  2. EDI data into Access database
    By cazper67 in forum Access
    Replies: 2
    Last Post: 07-24-2010, 05:57 PM
  3. Replies: 6
    Last Post: 04-18-2010, 03:41 AM
  4. Need Query to fetch last row in a table
    By gunapriyan in forum Queries
    Replies: 10
    Last Post: 02-19-2010, 11:46 PM
  5. Access Programming and Access Data Page
    By frmdread67 in forum Programming
    Replies: 0
    Last Post: 03-19-2008, 03:11 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
Tech Forums: Microsoft Office Forums