I am creating an Excel file from a query built within the module and need to update a field ("MFR") after the file is created so it changes the manufacturers name to the matching code within our sales system it is being import into. I have a table that I store all my manufacturers in and it stores the code that is shown on the vendors quote, the full name of the vendor I convert the code to when it is imported into the DB and the corresponding code we have in our sales system.
This is the query I run to convert the vendor code to the full name:
It is possible to run this same kind of query against an Excel file on a specific field/column? If not, I may have to change my process and involve a temp table to append all the data to and update it there before exporting to an Excel file.
This is the query I run to convert the vendor code to the full name:
SQL:
UPDATE tblNameMapping INNER JOIN tblTempFixture ON tblNameMapping.OldName = tblTempFixture.Manufacturer SET tblTempFixture.Manufacturer = [tblNameMapping].[NewName];
It is possible to run this same kind of query against an Excel file on a specific field/column? If not, I may have to change my process and involve a temp table to append all the data to and update it there before exporting to an Excel file.