G
gxf1681
Unregistered / Unconfirmed
GUEST, unregistred user!
各位大哥,你们好!<br> 请帮忙指点迷津,如何用代码实现将数据从EXCEL导入到SQLSERVER2000中来?我在Delphi7.0中,用ExcelApplication,ExcelWorkbook,ExcelWorksheet这些控件来写代码实现,部分代码如下:<br>procedure TForm1.Button1Click(Sender: TObject);<br>var<br> i:Integer ;<br> fName :String ;<br>begin<br> if OpenDialog1.Execute then<br> begin<br> fName := OpenDialog1.FileName ;<br><br> try<br> ExcelApplication1.Connect ;<br> except<br> MessageBox(0,'EXCEL 没有安装!','提示!',MB_OK);<br> exit ;<br> end ;<br> ExcelApplication1.Visible[0]:= false ;<br><br> try<br> ExcelApplication1.Workbooks.Open(fName,null,null,null,null,null,null,null,null,<br>null,null,null,null,null,null,0);<br> except<br> ExcelApplication1.Disconnect ;<br> ExcelApplication1.Quit ;<br> exit ;<br> end ;<br> end ;<br>end;<br>为什么当执行到ExcelApplication1.Workbooks.Open(fName,null,null,null,null,null,null,null,null,<br>null,null,null,null,null,null,0);这句代码的时候,出现地些读写错误呢,请各位大哥,帮忙指点一下!
代码: