<div>
Move first column after the second one, add two extra columns: one before the first column and one between two columns,<br />
put into the first cell text: <br />
update tableName set columnName = '<br />
propogate it all rows<br />
put into the first row third column text:<br />
'' where columnName = '<br />
propogate it all rows<br />
put into the first row fifth column text:<br />
';<br />
propogate it all rows<br />
<br />
copy all content to notpad for insance and remove all Tabs by command replace Tabs with empty string<br />
Your SQL script is ready to execute.<br />
<br />
Don't forget to replace tableName &amp;&nbsp;columnName with your real identifiers.<br />
<br />
If you need to execute such procedure automatically, you could record macro and play it in Excel
</div>


<div>
Hi<br />
That sould complicated to me<br />
What if i import the excel into a new table in the database and then run a sql script<br />
Not sure what the script would look like<br />
Gordon
</div>


<div>
In fact it was the simplest way. <br />
This article discribes how to import excel into a new table in sql server.<br />
<a href="https://support.microsoft.com/en-us/help/321686/how-to-import-data-from-excel-to-sql-server" rel="ugc">https://support.microsoft.com/en-us/help/321686/how-to-import-data-from-excel-to-sql-server</a><br />
<br />
Then you could execute the following command to update your data in original SQL server table with data from imported Excel table<br />
<br />
update EQUIP set EQNUM = (select &quot;New Equip No&quot; from XLImport9 where XLImport9.&quot;Equipment No&quot;=EQUIP.EQNUM )
</div>


<div>
Hi<br />
Well not quite there<br />
I have imported the excel file into(in the import I changed the values to varchar etc<br />
and called the table HullEQ<br />
I found the the EQNUM is used in several tables and view<br />
So created the following<br />
Update TASKEQ<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = TASKEQ.EQNUM)<br />
Update WOC<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOC.EQNUM)<br />
Update WOE<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOE.EQNUM)<br />
Update WOP<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOP.EQNUM)<br />
Update WOV<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOV.EQNUM)<br />
Update WOCHVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOCHVW.EQNUM)<br />
Update WOCVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOCVW.EQNUM)<br />
Update WODESCVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WODESCVW.EQNUM)<br />
Update WOEHVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEHVW.EQNUM)<br />
Update WOEQCVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEQCVW.EQNUM)<br />
Update WOEQLCOM<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEQLCOM.EQNUM)<br />
Update WOEQLHVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEQLHVW.EQNUM)<br />
Update WOEQLVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEQLVW.EQNUM)<br />
Update WOEQOVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEQOVW.EQNUM)<br />
Update WOEVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOEVW.EQNUM)<br />
Update WOHISTEQ<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOHISTEQ.EQNUM)<br />
Update WOPHVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOPHVW.EQNUM)<br />
Update WORHEQVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WORHEQVW.EQNUM)<br />
Update WOVHVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = WOVHVW.EQNUM)<br />
Update XWOEQVW<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = XWOEQVW.EQNUM)<br />
update EQUIP<br />
Set EQNUM = (select NewEQNUM from HullEQ where HullEQ.EQNUM = EQUIP.EQNUM)<br />
<br />
But for some reason the underlined red elements (NewEQNUM and HullEQ) says invalid column name or invalid object<br />
<br />
Any ideas<br />
Gordon
</div>


<div>
Are you sure you imported Excel data to the same database and schema?<br />
What is the result of the following query:<br />
<br />
select * from HullEQ <br />
<br />
?
</div>


<div>
Well it is very strange<br />
The table is shown in the correct database<br />
run Select * from HullEQ (if i hover over HullEQ iy says Invalid object name)<br />
when i press execute it returns all the data under headings EQNUM and NewEQNUM<br />
<br />
Gordon
</div>


<div>
OK I restarted the SQL server and now it recognised the table<br />
Now when I run the query is come back against every table<br />
<br />
Msg 515, Level 16, State 2, Line 1<br />
Cannot insert the value NULL into column 'EQNUM', table 'MP2Live.dbo.TASKEQ'; column does not allow nulls. UPDATE fails.<br />
<br />
The HullEQ table does not contain any Null values as far as I can determine<br />
<br />
Gordon
</div>


<div>
OK have changed all the lines<br />
Now I have to deal with duplicates before it will work, so will close this question
</div>


<div>
The original question was answered. Alternative solutions were proporsed. Tipical problem was resolved. There is no real problem with the final solution. So, objection
</div>


<div>
Hi<br />
What is this all about?
</div>


<div>
<div class="content wysiwyg-content">
I would like to update a field in my system with a value from an excel file<br />
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)<br />
The table I am trying to update is called EQUIP and the field is called EQNUM<br />
How would the query look?<br />
Gordon
</div>
</div>


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?
Gordon

How to update a field using an excel file

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.