<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ado_cc的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ado_cc</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ado_cc]]></copyright><item><title><![CDATA[把SQL语句转换存储过程]]></title><link>https://blog.youkuaiyun.com/ado_cc/article/details/6331204</link><guid>https://blog.youkuaiyun.com/ado_cc/article/details/6331204</guid><author>ado_cc</author><pubDate>Mon, 18 Apr 2011 14:57:00 +0800</pubDate><description><![CDATA[<br />create proc pr_name --pr_name存储过程名称
as
begin
xxx  ---SQL过程
end]]></description><category></category></item><item><title><![CDATA[delphi中导出excel文本格式]]></title><link>https://blog.youkuaiyun.com/ado_cc/article/details/6316002</link><guid>https://blog.youkuaiyun.com/ado_cc/article/details/6316002</guid><author>ado_cc</author><pubDate>Mon, 11 Apr 2011 16:56:00 +0800</pubDate><description><![CDATA[<br />  if OpenDialog1.Execute then
  begin
    try
      v:= CreateOleObject('Excel.Application');
      v.Workbooks.Open(OpenDialog1.FileName);
      Sheet:=v.Workbooks[1].WorkSheets[1];
      Sheet.Select;
      v.Visible:=false;
      Sheet.Col]]></description><category></category></item><item><title><![CDATA[excel数值类型转换为文本 ]]></title><link>https://blog.youkuaiyun.com/ado_cc/article/details/6314771</link><guid>https://blog.youkuaiyun.com/ado_cc/article/details/6314771</guid><author>ado_cc</author><pubDate>Mon, 11 Apr 2011 10:18:00 +0800</pubDate><description><![CDATA[<br />excel数值类型转换为文本  A例数据

Sub trimer()
    With Sheets("sheet1")
        ar = .[a1].CurrentRegion
        For i = 1 To UBound(ar)
            ar(i, 1) = trim(ar(i, 1))
        Next
        .[a1].Resize(UBound(ar)) = ar
    End With
End Sub

整]]></description><category></category></item><item><title><![CDATA[excel数据快速导入数据库]]></title><link>https://blog.youkuaiyun.com/ado_cc/article/details/6314586</link><guid>https://blog.youkuaiyun.com/ado_cc/article/details/6314586</guid><author>ado_cc</author><pubDate>Mon, 11 Apr 2011 09:01:00 +0800</pubDate><description><![CDATA[procedure TForm1.Button1Click(Sender: TObject);//在数据库中自动生成表 qqq
var s:string;
  ADOConn:TADOConnection;
  aDataSet:TADODataSet;
begin
  if OpenDialog1.Execute then
  begin
  ADOConn:=TADOConnection.Create(self);
  ADOConn.LoginPrompt:=false;
  ADO]]></description><category></category></item></channel></rss>