Anonymous Asked in Cars &Transportation ยท 2 weeks ago

How do I save an access file as an Excel file?

On the External Data tab, in the Export group, click Excel. In the Export - Excel Spreadsheet dialog box, review the suggested file name for the Excel workbook (Access uses the name of the source object). If you want, you can modify the file name. In the File Format box, select the file format that you want.


How do I save an Access file to Excel?

Export the data to Excel. Click on "File," then "Export" if you are using Microsoft Access 2003 or earlier. The "Export" dialog box appears. Click the drop-down box next to "Save as type." Choose one of the Excel formats (depending on your version of Excel).

Can you open an access file in Excel?

Import Access Data Open up a new workbook in Excel and click on the Data tab. Then under Get External Data click on From Access. Browse to the location of the database you want to import.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours