This interactive demo was created free with Storylane in 8 minutes. Create your own demo
How to Integrate a Microsoft Excel Database with Excel
It is very easy to integrate a Microsoft Excel database with Excel. Here’s a short guide on how to do it:
While your Microsoft Excel worksheet is currently in use, head over to the top menu bar and click 'Data'.
Choose 'From Access' from the available options under Get External Data.
Following that, provide all the necessary information, including your preferred MS Access data source, login credentials, and catalog. Once done, tap 'OK' to proceed.
Finally, input the required information one more time and then tap 'OK'. After completing these final steps, your Microsoft Access database will be integrated with Excel.
