Search results

Hmmm ok. Let's say if I link the file is there a way that I can copy the data from the excel Table that is link, to a new table so i can create PK to create a relationship. It will also auto copy new data when the excel file that is linked is updated.

Hi, I think I didn't interpret correctly. What i meant was after access has link to excel from the external data is it possible for me to create primary keys from the table created when the files has linked up together. Because the access keeps on preventing me from doing it. It will be a...

Does any one knows if after linking Excel to Access is there any way where I can allow access to add/ edit the data? For example let me use primary key to create a relationship. If possible pls help me as i really need help on this.