When using an Excel spreadsheet to create batch update statements, string fields must receive special formatting in order to run properly in SQL+. Most notably, this is the enclosure of the string in single quotes. The attached zip file contains several handy Excel macros that can do this, plus other formatting options for you.
Excel macros for use in formatting batch update spreadsheets Print
Modified on: Wed, 5 Nov, 2014 at 11:53 AM
Did you find it helpful?Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.