Excel table Import Access 2010 Time display Error resolution

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.