Murray Brown
asked on
Access Replacing Table Info with right primary keys
Hi
I have an Access table called "Manufacturers". It has an AutoNumber column called "ManufacturerPK" and a text column called "Manufacturer Name". I am constantly being given new lists in Excel that must be used to replace the entire table in the order that it appears in Excel. This creates a nightmare because
the key values in the "ManufacturerPK" column are already being used all over the database so I need to make sure that the same "ManufacturerPK" matches each "Manufacturer Name". How do I reload the table with new information without losing these matches?
Thanks
I have an Access table called "Manufacturers". It has an AutoNumber column called "ManufacturerPK" and a text column called "Manufacturer Name". I am constantly being given new lists in Excel that must be used to replace the entire table in the order that it appears in Excel. This creates a nightmare because
the key values in the "ManufacturerPK" column are already being used all over the database so I need to make sure that the same "ManufacturerPK" matches each "Manufacturer Name". How do I reload the table with new information without losing these matches?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER