On Fri, Aug 17, 2012 at 11:03 AM, 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) -----------------------------
Is there a range on this workbook? -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell -- 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
