How Do You Create An Excel Spreadsheet From A Database?
A powerful tool for financial management, Excel has unique analytical capabilities. Information contained in a database is compatible with Excel. You may want to create an Excel spreadsheet from your database information to take advantage of Excel’s robust abilities. You can export information from your database to Excel. Prepare for the export. Make sure you backup your database prior to beginning an export procedure. Open your database. Click the “Tables” view to open a window that displays all your tables. Double-click the table you would like to export. This will open the table and tell your database which table you are working with. On the file menu, click “Export…” This will open the “Export” dialogue box. Tell your database what type of file to create. In the “Export” dialogue box, choose “Excel 97-2007” in the “Save as type” drop-down menu. Name your file. Type a name for the file in the “File Name” box. Specify where you would like to save the file in the “Save In” drop-down
