Avatar of Gordon Hughes
Gordon Hughes
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

How to update a field using an excel file

I would like to update a field in my system with a value from an excel file
The excel file is called Hull Equip and it contains two columns Equipment No (which contains the existing values) and New Equip No (which contains the new number)
The table I am trying to update is called EQUIP and the field is called EQNUM
How would the query look?
Microsoft SQL Server

Avatar of undefined
Last Comment
Gordon Hughes

8/22/2022 - Mon