Administrator: Rave Reviews (Start) 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

Export the Data The beauty of working in Microsoft Office is the ability to integrate the applications and use all of the tools. Microsoft Excel has excellent tools for data analysis and charts. How do you get the information from a mighty Access table into Excel?   Try it: Export the Table Select a table: tblCustomers Go to External Data->Export->Excel.   File Name: tblCustomers Choose the following Export Options: Export data with formatting and layout. Open the file after the export is done.   Review the Results External Data-> Export ->Excel