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 imply that there are NULL values in the spreadsheet. this is absolutely untrue.
3. I tried using ADO because i understand DAOs have limitations, but no joy.
I have only just started programming in VB and this is my first project. Someone please Help
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 imply that there are NULL values in the spreadsheet. this is absolutely untrue.
3. I tried using ADO because i understand DAOs have limitations, but no joy.
I have only just started programming in VB and this is my first project. Someone please Help