Vlookup in Access2016

[shansakhi]

Hello Everybody,
I am new to Access and only know how to import data to from excel or csv file and create database.
I have created a database by importing around 70 excel files with more than 900 thousand rows in each excel. But while doing this process I forgot to add one columns to excel which is based on vlookup.
Is there a possibility that now I can add one additional column in Access 2916 and lookup data based on the fixed value which is available in database.
Else I need to rebuild entire database again with this column added in excel.

Regards,
Shan

 

[alansidman]

You can add a column (field) to your table. In a query, you can then create an Update Query to add the data you require to your table.

Here is a google link to learn about Update Queries. MS Access Update Query - Google Search

 

[JonXL]

Yikes! Please don't rebuild your whole database!

You can add the field by opening the table in design view. Once you have the field, you can update its value in all of the records by running an update query. It sounds like you might want the update value to be a dLookUp().

Create and run an update query - Microsoft Support

Use an update query in Access desktop databases to update or change the existing data in a set of records.

support.office.com

DLookup Function - Microsoft Support

Use the DLookup function in Access desktop databases to get the value of a particular field from a specified set of records.

support.office.com

 

[shansakhi]

Thank you Sir.. Will go through the links provided by you..