Tutorial Import Data Into Excel And. Importing Data from Microsoft Access Database. In the Save As dialog box under Save as type box choose the text file format for the worksheet.
In the Save As dialog box under Save as type box choose the text file format for the worksheet. Follow the steps in the Navigator dialog to connect to the table or query of your choice. On XelPlus you will get additional bonuses that are not available.
Go to File Save As.
This article describes data models in Excel 2013. Select Excel Link on the window this is. Step 3 Click From Access in the Get External Data group. Click OK and when the data appears click Load.