Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Data Access Problems
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...- wallas
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
Data Access Problems with Excel and DAO
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...- wallas
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
