importing data

By chabalan ·
I want to import an excel file into ms access. I want to select certain records whilst importing an excel file into ms access.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

It's easy

by Maevinn In reply to importing data

In Access, you can either create a link to the spreadsheet, or import it as a table. If you link to it, then updates made in either location will happen in both. Importing it means the data will only change in the location you're working on.

From Access, go to File: Get External Data: Import/Link. You will have to change the File Type drop down to Excel, then select the Excel File. There's a wizard that will walk you through the process, allowing you to identify if there are headers, etc, and to select the records you want to import.

Related Discussions

Related Forums