<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[dragonrabb的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/dragonrabb</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; dragonrabb]]></copyright><item><title><![CDATA[FileTracker : error FTK1011解决方法]]></title><link>https://blog.youkuaiyun.com/dragonrabb/article/details/7005750</link><guid>https://blog.youkuaiyun.com/dragonrabb/article/details/7005750</guid><author>dragonrabb</author><pubDate>Wed, 23 Nov 2011 21:02:11 +0800</pubDate><description><![CDATA[打开文件: C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.Targets 找到 true 改成 false]]></description><category></category></item><item><title><![CDATA[在access中批量导入excel文件]]></title><link>https://blog.youkuaiyun.com/dragonrabb/article/details/4006481</link><guid>https://blog.youkuaiyun.com/dragonrabb/article/details/4006481</guid><author>dragonrabb</author><pubDate>Fri, 20 Mar 2009 09:26:00 +0800</pubDate><description><![CDATA[ Function TransExcelToAccess(folderspec As String, tratablename As String)本函数读取folderspec目录下的XLS文件,并将每个文件的数据区域头两行的数据前面加个号,以表示导入的时候以文本方式导入On Error GoTo err1    Dim objRs As New ADODB.Recordset]]></description><category></category></item><item><title><![CDATA[在access中批量导入excel文件的问题]]></title><link>https://blog.youkuaiyun.com/dragonrabb/article/details/4005845</link><guid>https://blog.youkuaiyun.com/dragonrabb/article/details/4005845</guid><author>dragonrabb</author><pubDate>Thu, 19 Mar 2009 21:35:00 +0800</pubDate><description><![CDATA[ Function TransExcelToAccess(folderspec As String, tratablename As String)本函数读取folderspec目录下的XLS文件,并将每个文件的数据区域头两行的数据前面加个号,以表示导入的时候以文本方式导入On Error GoTo err1    Dim fs, f, f1, fc, s, a, b    S]]></description><category></category></item><item><title><![CDATA[ACCESS中如何在退出前更新当前用户的状态]]></title><link>https://blog.youkuaiyun.com/dragonrabb/article/details/3947046</link><guid>https://blog.youkuaiyun.com/dragonrabb/article/details/3947046</guid><author>dragonrabb</author><pubDate>Sun, 01 Mar 2009 14:32:00 +0800</pubDate><description><![CDATA[定义了一个全局变量User,原本想在主窗体的Close事件中用如下代码来使登录状态变成False    Dim strSQL As String    strSQL = "update tbluser set 登录状态 = False where [姓名] = " & User & ""    DoCmd.RunSQL strSQL实际发现在窗体关闭时User变量已经变成NULL值，最]]></description><category></category></item></channel></rss>