Hello,
I have a database at work that keeps an inventory of cameras by location. Every week I get a repair estimate sheet that lists cameras by serial number that need to be repaired. This list is sent to me in excel. I am trying to make it where I can just copy the column of serial numbers from the excel list sent to me and paste it directly into the database to return my information for those cameras. I would like to do this in a datasheet view where I paste the column, it looks them up and returns the information I need(warranty dates) by serial number. Any help would be greatly appreciated. Thanks.
Blake