What version of the .NET framework are you using? Also, how are you using the Excel file, is it a simple read, or are you opening the connection for read/write access?
If you can provide more of the surrounding code, as well as the expected output and the actual output, I can have a look at it and provide some input. Gabriel "Someone has to take a stand against evil, why should it not be me?" On Fri, Aug 17, 2012 at 12:03 PM, crocboy25 <[email protected]> wrote: > Hello Group, > > I am selecting rows from an excel spreadsheet. In the spreadsheet I have > like 2000+ rows, sometimes even more. When I run a spreadsheet it always > stop reading the rows on line number 899. I have checked the data on the > row, the row before and after and nothing seems out of the ordinary that > would make it stop. Only 7 columns of small amounts of data per column. > Any idea why the reader would stop on a particular line and not move > forward? It doesnt error out but when I check data adapter after it > executes it only has like 895 records(the first 4-5 lines in excel are used > as headers on my spreadsheets). I tried it with both an xls file and a xlsx > file with the same results. Any idea what could be causing this? Thanks for > any assistance. > > The string variable strConnection is set to ..... > Provider= Microsoft.ACE.OLEDB.12.0;Data > Source=c:\excel\upload\9907USS103402.XLSX; Extended Properties="Excel > 12.0;HDR=NO;IMEX=1;"; > > Dim pobjDataAdapter As OleDbDataAdapter > > pobjDataAdapter = New OleDbDataAdapter("select * from LASPBS",strConnection > ) > > -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
