Fetch Data From MS-Access

[kashif.special2005]

Hi,

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,
Kashif.

 

[cookiegary01]

Hi
The solution is in Excel.
In Excel you can go a certain cell then select data...import external data.... import data.
Then select the Access database... select the Table Student_Final_Result.
(Maybe you need to change some settings in Excel before it works).
Finally the data will be imported.
After that save the Excel file, and next time you need the results, you only need to select Update data.