You can use an UPDATE Query to do this. If you want to add an single
Supplier name then the SQL is something like:
UPDATE [YourTable]
SET [SupplierField] = '{Supplier Name}'
If you want to add different supplier names, the you have to work out the
algorithm to set the correct SupplierName for each Record.