When preparing an Excel spreadsheet to be imported into an Access database,the first row of the spreadsheet must have column headings that are recognized as field names by Access.

Question

Quizplus · Accepted Answer

Access uses the first row of the spreadsheet as the field names when importing data, so it is important to include column headings that match the field names in Access.

When Preparing an Excel Spreadsheet to Be Imported into an Access