Import Data into Access:
Review the New
before you leap. Many companies send spreadsheets with updated
product information. Before you import any data in Microsoft Access,
you should review it.
Review the New Data
Microsoft Excel 2010.
Browse for the file:
Please open the spreadsheet.
There are 10 new movies in this spreadsheet. The
first Row is the Header Row. It includes the following Fields:
Movie, Year, Rating, Genre and Stars.
Should You Be Looking For? These Field names MATCH the ones in
the Access Table, tblMovies.
step is in Access.