Enter Data in a Blank Field with 43,000 records

[Guest]

Would like to add supplier information to each record.

 

[Van T. Dinh]

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.

 

[Joseph Meehan]

Would like to add supplier information to each record.

I am curious. If you are adding the same data to 43,000 records it
sounds like poor database design. If you want to add different information
to different records, maybe you should give us more information so we can
offer a better answer.