Altair slc determining the type and length of Excel columns before importing
too long to post here, see GitHub
https://github.com/rogerjdeangelis/utl-altair-slc-determining-type-and-length-of-excel-columns-before-importing
CONTENTS
1 create excel odbc dsn
2 input sheet and named range
3 query for type length
4 create attrib statement
5 use attrib to make table
6 query named-range
7 query using proc r
8 drop down powershell
PROBLEM
Use Microsoft Access SQL functions like 'isnumeric' and 'length' to get type and length for each column in a excel sheet or named range.
Finally, use type and length to import the sheet or table.
