Numeric fields are showing up as NULL when a spreadsheet is read with RPG2SQL

From Support

C                   Eval      Rtn = SQL_DBOpenConn(SQL_Socket:      
C                             'Driver={Microsoft Excel Driver '     
C                             '(*.xls)}; ' +                        
C                             'DriverID=790; ' +                    
C                             'Dbq=u:\brad\customer files\' +       
C                             'gilbarco\budgetin.xls; ' +           
C                             'DefaultDir=u:\brad;' +               
C                             'Pwd=;')                              

C                   Eval      Rtn = SQL_DBOpenConn(SQL_Socket:          
C                             'Provider=Microsoft.Jet.OLEDB.4.0;' +     
C                             'Data Source=' +                          
C                             'u:\brad\customer files\' +               
C                             'gilbarco\budgetin.xls; ' +               
C                             'Extended Properties='  +                 
C                             '"Excel 8.0;HDR=No;IMEX=1;";')            

This IMEX setting solved the problem.