I am trying to import a excel file into access as a seperate table in the same database.
After importing the data; i want one column of that imported table to be copy exactly to the another table's column in the same database.
I also want to create a field in a form that will act as a master field to the other relted child field; for example, suppose i have a field name ProductID, when I enter productID the other child field to productid such as ProductName gets filled in automatically when I enter ProductID.
