Search results

Hi All I am trying to create a query to append new records from my NEW database into my old excel database..... The old DB has 4-5 extra tabs that the NEW database does not have so when I append, in those extra columns the new database will just have blank records since the column dosnt...

to work? barkt

Did you get it

This first table "SHEET1" is the file that I want to fill in from the lookup.. The ST and AFE coulmn would be my primary key.. I want to fill in the coulmn vBuild Status 3-4-18 Now the 2nd table is the table that contains the lookup, "vbuild Status 3-4-14 which i want to use as a...

how would i create a query? would it have to know what the primary key is ?

Thank you for your reply, what you have said is what i am looking for.... How would I do that? I'm fairly new to queries in access.

Hi Guys, I am trying to do a lookup from a field from one of my databases (DB1) onto another field in (DB2).... I have been using excel to do vlookups but a report that I do weekly I do atleast 7 lookups for the past weeks... So I am trying to find a way in access to do lookups and save those...