Update Specific columns in table in Access 2016 from another data Source

**arunchandra** · 02-13-2017, 02:10 PM

Hi All,

Can you please let me know how to update specific columns in a table in Access 2016 with data from another data source (excel file)..

Thanks,
Arun

**ranman256** · 02-13-2017, 02:22 PM

link the excel file as a table. (external data, link...)
create an update query on your 2 tables.

**arunchandra** · 02-13-2017, 02:40 PM

Hi Ranman,

Appreciate your response!..Can you please let me know how to convert a EXCEL data source to an access table..

Thanks,
Arun

Update Specific columns in table in Access 2016 from another data Source

Thread Tools

Update Specific columns in table in Access 2016 from another data Source

Similar Threads

Running Queries from another source in Access 2016

Want to update a table with the data calculated from specific queries

How to Update Data in a specific row based on the Primary Key Field data in the same table

Use an Update Query to Compare Tables and Add Non-Existing Data to Source Table

query to update columns based on values on other specific columns and values...

Posting Permissions