Excel table Import Access 2010 Time display Error resolution

An Excel table was imported in Access 2010, and the import was "linked to a data source by creating a linked table." When you import, you find that the date and time that you originally displayed correctly in Excel become numeric and the data type cannot be modified. As shown in the following illustration:

In order to display the time format correctly, we can manually change the format of the Time field in the Excel file.

After the fields in the Excel file time format, insert two columns, column C and D in the following figure, and enter the formula in column C:=if (b1= "", "", TEXT (B1, "hh:mm"))

When you enter, column C displays the same time, but the cell format is not in time format. Drag the "Ten" word at the bottom right of the selected C1 cell to change the formatting of the entire column. The following figure:

Select column C and copy to column D. The time shown in column D is not in the time format either. Finally, delete columns B and C.

You can then use Access to link the Excel file so that the time is displayed normally.