| Creating
an Access Database: A Primer for Resource Center Managers by
|
Exporting Access Tables (or Queries) to ExcelTable of ContentsIntroductionProcess Of Exporting Access Data to Excel Method 1 Method 2 For More Information
IntroductionYou may wish to move data from Access into an Excel worksheet. This is likely to be of interest to those who use Access to manage financial information. Often it's just easier to do sophisticated calculations or forecasting in Excel than in Access. The following is the process for moving information in a table or query into an Excel spreadsheet.Process Of Exporting Access Data (from a datasheet, form or report) to ExcelMethod 1: Export To an External File or DatabaseThis method is more cumbersome, but it does work.From the Database window, select the name of the table or query you want to export. From the File menu, click Save As/Export. In the Save As dialog box, select To An External File Or Database. Click OK. In the Save As Type box, click the spreadsheet format you want, likely Excel 97. Click the down arrow to the right of the Save In box, select the drive or folder to export to and double-click an existing spreadsheet, or enter a new name in the File Name box. Click Export and Access copies the table or query into the spreadsheet. Access puts the field names from the table or query in the first row of the spreadsheet and the data into the appropriate field. You then have to open Excel and open the XLS file. Warning: This process might overwrite existing data in your spreadsheet.
It might be wiser to enter the data into a new spreadsheet and then highlight,
copy and paste the data into the appropriate worksheets.
Method 2: Using Analyze It With MS ExcelA simpler method is to click the name of the table, query, form, or report you want to save and load into Microsoft Excel. (To save a selection of a datasheet, open the datasheet, and then select the portion of the datasheet before continuing). From the Tools menu, point to Office Links, and then click Analyze It With MS Excel.The output is saved as a Microsoft Excel file (.xls) in the same folder as Microsoft Access. Microsoft Excel automatically starts and opens the file for you to analyze. This method is much easier and you get the information in a format that's
ready to use immediately.
For More InformationLook at Load the output of a datasheet, form, or report into Microsoft Excel from Microsoft Help. |
|
Next: Helpful Hints Back: Future Considerations |