Wed, 23 Apr 2008 11:53:00 GMThttp://item.feedsky.com/~csdn.net/ojuju10/~1057922/68770755/1057922/1/item.htmlcomments/2317359.aspx0comments/commentRss/2317359.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2317359<p>到目前为止Access文件的格式有2种，一种是mdb格式文件，而另外一种是Accdb格式的文件，他们导入到Mssql数据库中方法都不一样。 </p><p>1、Mdb格式导入： </p><p>SELECT&nbsp; * into newtab&nbsp;&nbsp; FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'C:\database.mdb';&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'admin';'',link) </p><p>GO</p><p>Microsoft.Jet.OLEDB.4.0为ODBC驱动，C:\database.mdb为要导入的Mdb文件的物理路径，特别说明要导入的文件必须要上传到数据库所在的服务器，Link为Access表名。</p><p>2、Accdb格式导入： </p><p>SELECT *&nbsp;into newtab&nbsp; FROM OPENROWSET('Microsoft.Ace.OLEDB.12.0',&nbs<img src ="aggbug/2317359.aspx" width = "1" height = "1" />Wed, 23 Apr 2008 19:53:00 +0800ojuju10http://blog.csdn.net/ojuju10/archive/2008/04/23/2317359.aspx#Feedbackhttp://blog.csdn.net/ojuju10/archive/2008/04/23/2317359.aspxojuju10http://blog.csdn.net/ojuju10/archive/2008/04/23/2317359.aspxhttp://blog.csdn.net/ojuju10/rss.aspxcsdn.net/ojuju10/~1057922/68770755/1057922http://item.feedsky.com/~csdn.net/ojuju10/~1057922/68770756/1057922/1/item.htmlcomments/1943996.aspx0comments/commentRss/1943996.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1943996Asv格式的文件不同于文本文件，也不同Excel文件，同样是运用系统Openrowset()函数，但导入数据库的方式不一样，通过查询大量的资料，现在整理一下：<img src ="aggbug/1943996.aspx" width = "1" height = "1" />Tue, 18 Dec 2007 01:19:00 +0800ojuju10http://blog.csdn.net/ojuju10/archive/2007/12/17/1943996.aspx#Feedbackhttp://blog.csdn.net/ojuju10/archive/2007/12/17/1943996.aspxojuju10http://blog.csdn.net/ojuju10/archive/2007/12/17/1943996.aspxhttp://blog.csdn.net/ojuju10/rss.aspxcsdn.net/ojuju10/~1057922/68770756/1057922http://item.feedsky.com/~csdn.net/ojuju10/~1057922/68770757/1057922/1/item.htmlcomments/1893094.aspx0comments/commentRss/1893094.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1893094在mssql数据库中，结合系统函数rand()、round()、newid()在表中随机查询2列到3列，再将随机查询出来的列用逗号分隔开，并合并成一列输出！<img src ="aggbug/1893094.aspx" width = "1" height = "1" />Tue, 20 Nov 2007 01:36:00 +0800ojuju10http://blog.csdn.net/ojuju10/archive/2007/11/19/1893094.aspx#Feedbackhttp://blog.csdn.net/ojuju10/archive/2007/11/19/1893094.aspxojuju10http://blog.csdn.net/ojuju10/archive/2007/11/19/1893094.aspxhttp://blog.csdn.net/ojuju10/rss.aspxcsdn.net/ojuju10/~1057922/68770757/1057922http://item.feedsky.com/~csdn.net/ojuju10/~1057922/68770758/1057922/1/item.htmlcomments/1746074.aspx0comments/commentRss/1746074.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1746074优化SQL Server数据库<img src ="aggbug/1746074.aspx" width = "1" height = "1" />Thu, 16 Aug 2007 18:19:00 +0800ojuju10http://blog.csdn.net/ojuju10/archive/2007/08/16/1746074.aspx#Feedbackhttp://blog.csdn.net/ojuju10/archive/2007/08/16/1746074.aspxojuju10http://blog.csdn.net/ojuju10/archive/2007/08/16/1746074.aspxhttp://blog.csdn.net/ojuju10/rss.aspxcsdn.net/ojuju10/~1057922/68770758/1057922http://item.feedsky.com/~csdn.net/ojuju10/~1057922/68770759/1057922/1/item.htmlcomments/1746057.aspx0comments/commentRss/1746057.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1746057用游标的方法实现:已知一个字符串去查询满足这个字符串所有的记录<img src ="aggbug/1746057.aspx" width = "1" height = "1" />Thu, 16 Aug 2007 18:05:00 +0800ojuju10http://blog.csdn.net/ojuju10/archive/2007/08/16/1746057.aspx#Feedbackhttp://blog.csdn.net/ojuju10/archive/2007/08/16/1746057.aspxojuju10http://blog.csdn.net/ojuju10/archive/2007/08/16/1746057.aspxhttp://blog.csdn.net/ojuju10/rss.aspxcsdn.net/ojuju10/~1057922/68770759/1057922http://item.feedsky.com/~csdn.net/ojuju10/~1057922/68770760/1057922/1/item.htmlcomments/1611431.aspx0comments/commentRss/1611431.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1611431将mssql server数据库中的记录导入到excel表中！<img src ="aggbug/1611431.aspx" width = "1" height = "1" />Wed, 16 May 2007 21:19:00 +0800ojuju10http://blog.csdn.net/ojuju10/archive/2007/05/16/1611431.aspx#Feedbackhttp://blog.csdn.net/ojuju10/archive/2007/05/16/1611431.aspxojuju10http://blog.csdn.net/ojuju10/archive/2007/05/16/1611431.aspxhttp://blog.csdn.net/ojuju10/rss.aspxcsdn.net/ojuju10/~1057922/68770760/1057922