Which of the following displays in Access if the imported Excel column contains mostly numbers,but also includes some dates?
A) three-digit numbers
B) four-digit numbers
C) five-digit numbers
D) six-digit numbers

Question

Quizplus · Accepted Answer

When importing an Excel column into Access that contains mostly numbers but also includes some dates, Access interprets the dates as their serial number equivalent. Dates in Excel are stored as serial numbers, where each whole number represents a unique day counting from January 1, 1900. This results in five-digit numbers for dates in recent years.

Which of the Following Displays in Access If the Imported