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...
I need to import data from excel, process it and write it to a SQL server 7 table.
Problems:
1. The DAO control indicates that i have over a thousand rows of data in the spreadsheet than i actually have. ihave only got 210 records, so i'm baffled
2. For some reason i keep getting errors that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.