Step 55 validating and copying link data

The demo uses Excel 2010, and it’s the same in Excel 2007, except that there is an Office button, instead of a File tab.

Rows You cannot filter or skip rows during the import operation.When you import data, Access creates a copy of the data in a new or existing table without altering the source Excel worksheet.The steps in this section explain how to prepare for and run an import operation, and how to save the import settings as a specification for later reuse.As you proceed, remember that you can import data from only one worksheet at a time.You cannot import all the data from a whole workbook at the same time. Result: Note: to remove data validation from a cell, select the cell, on the Data tab, in the Data Tools group, click Data Validation, and then click Clear All.


Leave a Reply