If data from an Excel worksheet is imported into Access and no column headings exist,the data will import using:
A) Import1, Import2, Import3, etc.
B) Access1, Access2, Access3, etc.
C) Field1, Field2, Field3, etc.
D) FieldA, FieldB, FieldC, etc.

Question

Quizplus · Accepted Answer

Access will import the data using generic column headings of Field1, Field2, Field3, etc. It is important to include column headings in Excel before importing to Access to ensure that the data is properly categorized and labeled.

If Data from an Excel Worksheet Is Imported into Access