ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How can I extract Microsoft excel table from a data base management system application like Microsoft access?

user-image
تم إضافة السؤال من قبل Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)
تاريخ النشر: 2015/04/29
Shatha Al Ghabra
من قبل Shatha Al Ghabra , Researcher & IT Trainer , Training Centers

Hi

In Access you can right click on the table, then choose the command "export" "Excel" , after that you will see the dialog "Export-Excel spread sheet"  enable "Export data with formatting and layout" and enable "open the destination file after the export operation is complete" and finally press "ok" to see your Access table in the Excel.

 

Musharif Hussain
من قبل Musharif Hussain , Sr. Engineer (Instrumentation &Control) , Matiari Group

Ok, agree with above answers, good luck

Ahmed Maher allam
من قبل Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

open ms access and click on external database tab and choose excel command from the group export then save your sheet any where you like

Vinod Jetley
من قبل Vinod Jetley , Assistant General Manager , State Bank of India

Using the Access “Import & Link” tab, specific tables or frames within Excel can be selected, linked to and referenced within your database, but the numerical data must be updated at source i.e. within Excel.

مستخدم محذوف‎
من قبل مستخدم محذوف‎

In Excel on the Data Ribbon; Get External Data, select Access Data Base.

Then the normal pivot tables and data extraction functions work the same way.  

Use either filters, or pivot tables.

المزيد من الأسئلة المماثلة