Hi I am sure there is a simple way to do this, but I cant for the life of me think what it is.
I have a table in my DB called, devices. This contains all the information about various devices we have deployed in the field.
These devices are also contained in 2 other separate MySQL DB's.
What I need to do is add 2 additional field to my access table for the DeviceRecno and DeviceID of the same device from the MySQL DB's.
Adding the field is easy, but I cant think of a way to enter the recno and ID from the other DB's without typing them in manually for each one.
The common between them all is the serial number of the device, and I can get a list of serial numbers, recno's and ID in an excel sheet.
Could someone suggest an easy, say like a vlookup in excel to easily populate all the existing records with the recno and id's from the other db's?
I am fully aware that the set up is a little strange to say the least, it is something that has happened through a multitude of reasons and is going to be looked at shortly and re-done to be in a much better way.
When I created the access system there was no intention to link it to the other DB's for any reason, but that has now changed due to a lot of reasons.
Any suggestions would be most helpful.
Thanks
I have a table in my DB called, devices. This contains all the information about various devices we have deployed in the field.
These devices are also contained in 2 other separate MySQL DB's.
What I need to do is add 2 additional field to my access table for the DeviceRecno and DeviceID of the same device from the MySQL DB's.
Adding the field is easy, but I cant think of a way to enter the recno and ID from the other DB's without typing them in manually for each one.
The common between them all is the serial number of the device, and I can get a list of serial numbers, recno's and ID in an excel sheet.
Could someone suggest an easy, say like a vlookup in excel to easily populate all the existing records with the recno and id's from the other db's?
I am fully aware that the set up is a little strange to say the least, it is something that has happened through a multitude of reasons and is going to be looked at shortly and re-done to be in a much better way.
When I created the access system there was no intention to link it to the other DB's for any reason, but that has now changed due to a lot of reasons.
Any suggestions would be most helpful.
Thanks