Jump to content

Import Access Data into Excel


Recommended Posts

Import Access Data into Excel

It's fairly easy to share data between Office applications. Often, you can just cut and paste data. When there's a lot of data, or you want to filter data, use Microsoft Query instead. For instance, to import Access data into an Excel spreadsheet, complete the following steps: Position the cursor in the top-right cell of the Excel range in which you want to store the imported data. Next, select Data, Get External Data, New Database Query. Select MS Access Database and click OK. Then, locate the MDB file that contains the data you want to import and click OK. Double-click the table or query. If you want to omit some of the fields, click the plus sign next to the table or query, and then double-click the fields individually. Click Next to continue. Specify filtering criteria and click Next. At this point, specify the sort order and click Next. Select the Return Data To Microsoft Excel option and click Finish. If you plan to run this import again, click Save Query.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...