Vlookup in Access2016

shansakhi

Board Regular
Joined
Apr 5, 2008
Messages
213
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

Well-known Member
Joined
Feb 26, 2007
Messages
5,042
Office Version
2019
Platform
Windows
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

Board Regular
Joined
Feb 5, 2018
Messages
226
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().


 

Forum statistics

Threads
1,078,373
Messages
5,339,809
Members
399,328
Latest member
Jasonabelly

Some videos you may like

This Week's Hot Topics

Top