Help required in ExcelDriver Part in ASP
-
Hi Friends, The following code has been used in one of the asp page to fetch data from excel sheet and insert into table. Excel Driver part is used to do this. But however the excel sheet includes more than 130 rows. But when importing it just imports only 91 row and the remaining rows are not getting uploaded in the table. Please Please help. ExcelDriver Part: set objConn = Server.CreateObject("ADODB.Connection") set rsExcel = Server.CreateObject("ADODB.RecordSet") strName = "\Uploads\bicreports\" & strFileName servername = server.mappath(strName) ' Create a connection string. strConnectionString = "DBQ= " & servername & _ ";DefaultDir=" & SERVER.MAPPATH("/bicreports/") & _ ";Driver={Microsoft Excel Driver (*.xls)}" & _ ";DriverId=22;FIL=excel 8.0" & _ ";ImplicitCommitSync=Yes;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5" & _ ";SafeTransactions=0;Threads=3;UserCommitSync=Yes;" Is there anything wrong with above code attributes...which forces to read only 91 rows... Its very urgent...Please help... Thanks lot in advance. priyaahh