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
