I'm having problems reading data from an Excel spreadsheet with a DAO component. Values in each column is detected and read except the last column which contains numeric values.
For some reason, if I add a letter to the numeric value, the program reads it fine but when I remove it leaving only the numeric value, it sees it as NULL.
For some reason, if I add a letter to the numeric value, the program reads it fine but when I remove it leaving only the numeric value, it sees it as NULL.
