MAXSCANROWS With Excel and ADO/OBDC
Posted on 2002-06-16
Using VC6, SP5 with ADO and finding that in connecting to Excel the MaxScanRows=0 seems to be ignored [fails in ODBC as well and I assume the same driver is used]. A column containing data with many blank values is ignored when there is data in the rows below row 15. The connection string is:
"Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Excel Files;DBQ=C:\Temp\test.xls;DefaultDir=C:\Temp;DriverId=790;MaxBufferSize=2048;PageTimeout=5;ColNameHeader=True;MaxScanRows=0;""
Using 25 also fails so the default of 7 is always used. This is rather annoying and I am at loss as to why this behaviour occurs. Can anyone offer any suggestions please?
Thanks in advance