Compare the name in excel with the name in access, and bring the ACCESS value with the same name into the excel table.

You can import data from ACCESS into EXCEL and then process it in EXCEL.

1, ACCESS data is imported into EXCEL, in EXCEL: data-get external data-import tables in your database from ACCESS, assuming they are imported into SHEET2;

2. Assume that the imported data column A is the data to be obtained, column B is the name, and the formula is used in column C in the following figure (your screenshot). Assume that the data starts from B7 and the formula is C7:

=VLOOKUP(B7，IF({ 1，0}，sheet2！ B$ 1:B$！ 1000，sheet2！ 65438 USD +0:65438 USD +0000), 2,0)

Pull down.

Chen Long Li Zongwei (badminton men's singles two giants)

How to write a press release for the theme class meeting of "Being Civilized and Walking with Integrity"

The name of the self-introduction diary was changed to Chen Zixuan.

How to bring pets when American immigrants enter the country?

Why is the extracurricular detective team not popular?

Why can't the New Deal and the preparatory constitutionalism at the end of the 20th century save the fate of the Qing Dynasty?

I heard that the enrollment plan of Shiyan key high school has changed?

The latest template of power of attorney for branch offices authorized by the head office

How to sign the parents' signature of the second-year math calculation expert?

One-minute interview to introduce yourself.