SQL UPDATE statement in MS Excel
Hi All,
I have a request to perform a column update in ap_invoices_all table. There are around 1000 rows to be updated. The input is in the form of MS Excel.
Can somebody suggest how to make an update statement using MS Excel.
My query using excel should look like below:
UPDATE AP_INVOICES_ALL
SET description = '',
last_update_date = ,
last_updated_by =
WHERE org_id =
AND vendor_site_id =
AND invoice_num = ''
Regards,
Radhika.
I have a request to perform a column update in ap_invoices_all table. There are around 1000 rows to be updated. The input is in the form of MS Excel.
Can somebody suggest how to make an update statement using MS Excel.
My query using excel should look like below:
UPDATE AP_INVOICES_ALL
SET description = '',
last_update_date = ,
last_updated_by =
WHERE org_id =
AND vendor_site_id =
AND invoice_num = ''
Regards,
Radhika.
0