This is where you can select what type of data will you be using for the import. This action is shown as follows.Īfter you click OK, another next dialog box titled Import Data will pop up. We will choose Expenses table from the wedding database and then click OK. Next you will get the Select Table dialog box where you can choose the actual table. ![]() Select your data source which will be a Microsoft access database and then click Open.įor our practice today, we’ll be using a wedding database (Wedding.accdb) from My Documents folder. We have included a screen capture of this step right below. When you click on this, a new dialog box will pop up. ![]() Next select From Access command on the Get External Data group. Go ahead and launch Microsoft Excel and open up a new workbook using the Office button. Here is a screen shot of the Data Tab in Microsoft Excel 2007. The data tab has the following groups that you can utilize: We will show you how to import data from a Microsoft Access database and also from a text file. ![]() Using this tab, you can import data from external sources including but not limited to a text files, Microsoft Access databases, web pages, xml documents, Microsoft Query, Microsoft SQL Server databases. In our lesson today on Microsoft excel office , we will be looking at the Data Tab in Excel 2007.
0 Comments
Leave a Reply. |