Altair slc excel using undocumented excel vba and sql functions to prepare a sheet for import

Roger DeAngelis_21630

Altair slc excel using undocumented excel vba and sql functions to prepare a sheet for import

Too long to post here, see github
https://github.com/rogerjdeangelis/utl-altair-slc-excel-using-undocumented-excel-vba-and-sql-functions-to-prepare-a-sheet-for-import

PROBLEM (Remove '%' characters around name variable using just excel vba and sql

CONTENTS

1 slc remove tab charcacter

2 slc proc r (best solution handles length issues automatically)

3 slc list UNDOCUMENTED vba and sql functions?

4 could not get pyodbc to work

  NOTE: pyodbc.Error: ('HYC00', '[HYC00] [Microsoft][ODBC Excel Driver]Optional feature not implemented

  (106) (SQLSetConnectAttr(SQL_ATTR_AUTOCOMMIT))')

  (kept suggesting python excel packages.