Question

读取EXCEL到DataGridView 少数据？？？？？？？？？

我读取的数据很多，当读取数据少时，数据就正常，多时坐标数据就漏了。代码如下：
string strConn = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
读取某列坐标数值（所有）：95.4330,42.3245 95.4400,42.3245 95.4400,42.3345 95.4500,42.3345 95.4500,42.3445 95.4400,42.3445 95.4400,42.3530 95.4515,42.3530 95.4515,42.3345 95.4815,42.3345 95.4815,42.3400 95.4930,42.3400 95.4930,42.3422 95.5045,42.3422 95.5045,42.3437 95.5330,42.3437 95.5330,42.3537 95.5430,42.3537 95.5430,42.3445 95.5400,42.3445 95.5400,42.3430 95.5100,42.3430 95.5100,42.3415 95.4945,42.3415 95.4945,42.3300 95.4800,42.3300 95.4800,42.3330 95.4630,42.3330 95.4630,42.3245 95.4500,42.3245 95.4500,42.3200 95.4330,42.3200

只能读取数值（部分）：95.4330,42.3245 95.4400,42.3245 95.4400,42.3345 95.4500,42.3345 95.4500,42.3445 95.4400,42.3445 95.4400,42.3530 95.4515,42.3530 95.4515,42.3345 95.4815,42.3345 95.4815,42.3400 95.4930,42.3400 95.4930,42.3422 95.5045,42.3422 95.5045,42.3437 95.5330,42.3437

当读取少量几行时数据正常 ，数据为读取某列坐标数值（所有）数据，但当读取行数多时就只能读取数值（部分） 数据少了一些、、、、、、、、有高手来解决下？？？？？？？？？？？
DataGridView 追加数据不行~因为我调试的时候 在DataTable 中 数据已经是缺少的了，也就是在 SELECT * FROM SHEET&1 查询出来数据就是不全的了~DataGridView 与 DataTable 绑定数据源数据都不全，再怎么追加？

Answer 1

strSQL="SELECT * FROM [SHEET1$]"
我测试了一下，能够读取完整的数据。。。

======================================
读取一个数据，放入DataGridView中

记得DataGridView要追加数据。

Answer 2

1：你执行完excel读取之后，执行一个选择：delete * from 表 where 列 is NULL.
2：你要装OFFICE2007