SQL Server - Generate SQL INSERT from Excel
Posted by: SQL Server DBA,
on 27 Jan 2012 |
View original | Bookmarked: 0 time(s)
Generate SQL Server INSERT statements with Excel Concatenate.A developer requested access to a Production database. The details were to COPY and PASTE from a Excel spreadsheet into Access , which then updated SQL Server. Upon asking him , why he used this method , he said Its the way I always insert this data to the lookup table.There are better ways . One way , is to use the Concatenate function in Excel. It concatenates the ascii portions of the statement, adding single quotes where relevant.In...