B bob horn Jun 26, 2008 #1 Using ole I read the sheet into a dataset, but the first row is missing when I iterate through "foreach"... row and "foreach"...column.
Using ole I read the sheet into a dataset, but the first row is missing when I iterate through "foreach"... row and "foreach"...column.
R RB Smissaert Jun 26, 2008 #2 Post the code, but if I remember well you have to specify somewhere if the first row are the field headers or the first row of the data. RBS
Post the code, but if I remember well you have to specify somewhere if the first row are the field headers or the first row of the data. RBS
B bob horn Jun 26, 2008 #3 bob horn said: Using ole I read the sheet into a dataset, but the first row is missing when I iterate through "foreach"... row and "foreach"...column. Click to expand... Found problem myself. Needs ";HDR=No" at the end of the connection string!!!
bob horn said: Using ole I read the sheet into a dataset, but the first row is missing when I iterate through "foreach"... row and "foreach"...column. Click to expand... Found problem myself. Needs ";HDR=No" at the end of the connection string!!!
