SQL数据导入导出问题总结

叁歲伎倆 2021-12-17 05:41 274阅读 0赞

大家打开这个链接可以看到很多数据库的连接方法。[http://www.connectionstrings.com/][http_www.connectionstrings.com]  
这些数据库之间的数据交换就是这个贴子所要总结的内容。

（一）SQL Server之间  
把远程数据库中的数据导入到本地数据库。  
[http://community.csdn.net/Expert/topic/5079/5079649.xml?temp=.7512018][http_community.csdn.net_Expert_topic_5079_5079649.xml_temp_.7512018]  
[http://community.csdn.net/Expert/topic/5011/5011278.xml?temp=.1658899][http_community.csdn.net_Expert_topic_5011_5011278.xml_temp_.1658899]  
[http://community.csdn.net/Expert/topic/4982/4982625.xml?temp=.8189966][http_community.csdn.net_Expert_topic_4982_4982625.xml_temp_.8189966]

把A库里的其中几个表和视图导入B库  
[http://community.csdn.net/Expert/topic/5042/5042648.xml?temp=.2556574][http_community.csdn.net_Expert_topic_5042_5042648.xml_temp_.2556574]

sql2005的数据库导入sql2000中  
[http://community.csdn.net/Expert/topic/4954/4954820.xml?temp=.3408625][http_community.csdn.net_Expert_topic_4954_4954820.xml_temp_.3408625]  
在SQL2005中 如何导入 SQL2000中的Analysis Service ?  
[http://community.csdn.net/Expert/topic/4713/4713032.xml?temp=2.752322E-02][http_community.csdn.net_Expert_topic_4713_4713032.xml_temp_2.752322E-02]

英文版sql server2005中bcp导出中文乱码问题  
[http://community.csdn.net/Expert/topic/5024/5024662.xml?temp=.7404596][http_community.csdn.net_Expert_topic_5024_5024662.xml_temp_.7404596]

如何将一个由SQL保存出来的\*.bas文件再导回到SQL中  
[http://community.csdn.net/Expert/topic/4944/4944630.xml?temp=.8225672][http_community.csdn.net_Expert_topic_4944_4944630.xml_temp_.8225672]

（二）SQL Server --> Access

将SQL数据导出至Access（SQL与Access同一台机器上）  
[http://community.csdn.net/Expert/topic/4919/4919937.xml?temp=.2461359][http_community.csdn.net_Expert_topic_4919_4919937.xml_temp_.2461359]  
将SQL数据导出至Access（SQL与Access不在同一台机器上）  
[http://community.csdn.net/Expert/topic/4906/4906691.xml?temp=.1377222][http_community.csdn.net_Expert_topic_4906_4906691.xml_temp_.1377222]  
[http://community.csdn.net/Expert/topic/4917/4917015.xml?temp=.7591364][http_community.csdn.net_Expert_topic_4917_4917015.xml_temp_.7591364]

（三）Access --> SQL Server  
[http://faq.csdn.net/FAQUnfurl.aspx?id=214875][http_faq.csdn.net_FAQUnfurl.aspx_id_214875]

为什么access与sqlserver2000导入导出时，数据库结构变了，默认主键，自动编号全没了？  
[http://community.csdn.net/Expert/topic/4712/4712570.xml?temp=.3942224][http_community.csdn.net_Expert_topic_4712_4712570.xml_temp_.3942224]

（四）txt（记事本）--> SQL Server  
[http://community.csdn.net/Expert/topic/5045/5045602.xml?temp=.0278284][http_community.csdn.net_Expert_topic_5045_5045602.xml_temp_.0278284]  
TXT文件导入数据库出现乱码  
[http://community.csdn.net/Expert/topic/4939/4939026.xml?temp=.4465296][http_community.csdn.net_Expert_topic_4939_4939026.xml_temp_.4465296]  
关于上千份大文本存入Sqlserver  
[http://community.csdn.net/Expert/topic/4973/4973969.xml?temp=.4392816][http_community.csdn.net_Expert_topic_4973_4973969.xml_temp_.4392816]

（五）SQL Server --> txt  
[http://community.csdn.net/Expert/topic/4906/4906039.xml?temp=.6642267][http_community.csdn.net_Expert_topic_4906_4906039.xml_temp_.6642267]  
SQL导出TXT或HTML求助  
[http://community.csdn.net/Expert/topic/5031/5031048.xml?temp=1.302737E-02][http_community.csdn.net_Expert_topic_5031_5031048.xml_temp_1.302737E-02]

（六）Excel --> SQL Server  
[http://community.csdn.net/Expert/topic/5002/5002120.xml?temp=.4375727][http_community.csdn.net_Expert_topic_5002_5002120.xml_temp_.4375727]  
[http://community.csdn.net/Expert/topic/5086/5086098.xml?temp=.6402094][http_community.csdn.net_Expert_topic_5086_5086098.xml_temp_.6402094]  
[http://community.csdn.net/Expert/topic/4940/4940738.xml?temp=.8665125][http_community.csdn.net_Expert_topic_4940_4940738.xml_temp_.8665125]  
[http://community.csdn.net/Expert/topic/4938/4938969.xml?temp=1.918972E-03][http_community.csdn.net_Expert_topic_4938_4938969.xml_temp_1.918972E-03]  
[http://community.csdn.net/Expert/topic/4892/4892120.xml?temp=.1775324][http_community.csdn.net_Expert_topic_4892_4892120.xml_temp_.1775324]  
使用Excel导入数据库时,遇到这么个奇怪的问题,当Excel的一列中的数据类型明显不同时就会直接eof,??  
[http://community.csdn.net/Expert/topic/4929/4929620.xml?temp=.2570154][http_community.csdn.net_Expert_topic_4929_4929620.xml_temp_.2570154]

（七）DBF --> SQL Server  
[http://community.csdn.net/Expert/topic/5070/5070623.xml?temp=6.957644E-02][http_community.csdn.net_Expert_topic_5070_5070623.xml_temp_6.957644E-02]

其他问题

怎样把数据库中的题目经过vb 导到word  
[http://faq.csdn.net/FAQUnfurl.aspx?id=215243][http_faq.csdn.net_FAQUnfurl.aspx_id_215243]

使用作业来完成DTS操作。  
[http://community.csdn.net/Expert/topic/5046/5046974.xml?tep=.9785425][http_community.csdn.net_Expert_topic_5046_5046974.xml_tep_.9785425]

还可以看看这个链接  
[http://blog.csdn.net/dutguoyi/archive/2006/10/16/1337274.aspx][http_blog.csdn.net_dutguoyi_archive_2006_10_16_1337274.aspx]

xml --> sql server  
[http://community.csdn.net/Expert/topic/5041/5041228.xml?temp=.8233911][http_community.csdn.net_Expert_topic_5041_5041228.xml_temp_.8233911]

oracle --> sql server  
[http://community.csdn.net/Expert/topic/5019/5019542.xml?temp=2.604312E-02][http_community.csdn.net_Expert_topic_5019_5019542.xml_temp_2.604312E-02]

[http://support.microsoft.com/kb/320125][http_support.microsoft.com_kb_320125]

[http://fufun.cn/show.aspx?id=dC8yMDAyMDUzMC8xNS83NjUxOTEuaHRtbA\_x003D\_\_x003D][http_fufun.cn_show.aspx_id_dC8yMDAyMDUzMC8xNS83NjUxOTEuaHRtbA_x003D_x003D]\_

在用Bulk Insert导入数据时的日期时间格式问题,  
原因：bulk insert 不能转换数据类型，如果时间格式不正确就会出错。  
[http://community.csdn.net/Expert/topic/5100/5100692.xml?temp=.0559656][http_community.csdn.net_Expert_topic_5100_5100692.xml_temp_.0559656]

Excel --> SQL Server  
导入时添加额外列，  
例如 EXECL表的结构为 名称,内容,类别，  
SQLserver表的结构为 名称,内容,类别,属性  
[http://community.csdn.net/Expert/topic/5105/5105613.xml?temp=.3277399][http_community.csdn.net_Expert_topic_5105_5105613.xml_temp_.3277399]

补上  
Excel --> SQL Server  
导入时列名调整补充  
[http://community.csdn.net/Expert/topic/5086/5086098.xml?temp=.5973932][http_community.csdn.net_Expert_topic_5086_5086098.xml_temp_.5973932]

SQL Server 2005 --> SQL Server 2000  
[http://dev.csdn.net/author/taito/840c28a03ec0432492db18a329125bb5.html][http_dev.csdn.net_author_taito_840c28a03ec0432492db18a329125bb5.html]  
[http://community.csdn.net/Expert/topic/4954/4954820.xml?temp=.495083][http_community.csdn.net_Expert_topic_4954_4954820.xml_temp_.495083]

SQL Server 2005 --> SQL Server 2000  
用sql2005的导入导出工具将所有SQL2005的表和数据导出到SQL2000下，但是所有的主键、索引、关系、默认值全部丢了。  
[http://community.csdn.net/Expert/topic/4905/4905590.xml?temp=6.176394E-02][http_community.csdn.net_Expert_topic_4905_4905590.xml_temp_6.176394E-02]

MySql --> SQL Server  
[http://topic.csdn.net/t/20031203/09/2521118.html][http_topic.csdn.net_t_20031203_09_2521118.html]  
[http://topic.csdn.net/t/20030407/11/1627991.html][http_topic.csdn.net_t_20030407_11_1627991.html]

SQL Server --> DB2  
[http://www.21cnvip.com/csdn/default.aspx?q=20021105/10/1149089.html][http_www.21cnvip.com_csdn_default.aspx_q_20021105_10_1149089.html]

大家可以在下面的链接来搜索CSDN技术社区文档，很大的技术宝藏啊。  
[http://search.csdn.net/search/null/1/dev/][http_search.csdn.net_search_null_1_dev]

SQL Server 2000 --> SQL Server 7.0  
SQL2000数据导入到SQL7,那些设置为主键的没有了  
[http://community.csdn.net/Expert/topic/5004/5004254.xml?temp=.1570246][http_community.csdn.net_Expert_topic_5004_5004254.xml_temp_.1570246]

SQL Server 2005 --> SQL Server 2000  
2005导出的脚本为什么在2000运行总是出错？  
[http://community.csdn.net/Expert/topic/4682/4682496.xml?temp=.6038324][http_community.csdn.net_Expert_topic_4682_4682496.xml_temp_.6038324]

SQL Server之间复制数据库  
[http://community.csdn.net/Expert/topic/4835/4835266.xml?temp=.7495233][http_community.csdn.net_Expert_topic_4835_4835266.xml_temp_.7495233]

SQL Server 2000 --> SQL Server 2000  
DTS包的制作  
[http://community.csdn.net/Expert/topic/5006/5006594.xml?temp=.2426111][http_community.csdn.net_Expert_topic_5006_5006594.xml_temp_.2426111]

SQL Server 2005 --> Excel  
数据长度为255,出错  
[http://community.csdn.net/Expert/topic/4951/4951804.xml?temp=.2144739][http_community.csdn.net_Expert_topic_4951_4951804.xml_temp_.2144739]

SQL Server 2005 --> SQL Server 2000  
[http://community.csdn.net/Expert/topic/5089/5089204.xml?temp=.4461328][http_community.csdn.net_Expert_topic_5089_5089204.xml_temp_.4461328]

SQL Server 2000 --> SQL Server 2000  
导出表的所有结构、所有数据  
[http://community.csdn.net/Expert/topic/5092/5092752.xml?temp=.8595545][http_community.csdn.net_Expert_topic_5092_5092752.xml_temp_.8595545]

TrackBack: [http://blog.csai.cn/user1/19065/archives/2006/8916.html][http_blog.csai.cn_user1_19065_archives_2006_8916.html]

转载于:https://www.cnblogs.com/hdjjun/archive/2008/11/12/1332025.html

[http_www.connectionstrings.com]: http://www.connectionstrings.com/
[http_community.csdn.net_Expert_topic_5079_5079649.xml_temp_.7512018]: http://community.csdn.net/Expert/topic/5079/5079649.xml?temp=.7512018
[http_community.csdn.net_Expert_topic_5011_5011278.xml_temp_.1658899]: http://community.csdn.net/Expert/topic/5011/5011278.xml?temp=.1658899
[http_community.csdn.net_Expert_topic_4982_4982625.xml_temp_.8189966]: http://community.csdn.net/Expert/topic/4982/4982625.xml?temp=.8189966
[http_community.csdn.net_Expert_topic_5042_5042648.xml_temp_.2556574]: http://community.csdn.net/Expert/topic/5042/5042648.xml?temp=.2556574
[http_community.csdn.net_Expert_topic_4954_4954820.xml_temp_.3408625]: http://community.csdn.net/Expert/topic/4954/4954820.xml?temp=.3408625
[http_community.csdn.net_Expert_topic_4713_4713032.xml_temp_2.752322E-02]: http://community.csdn.net/Expert/topic/4713/4713032.xml?temp=2.752322E-02
[http_community.csdn.net_Expert_topic_5024_5024662.xml_temp_.7404596]: http://community.csdn.net/Expert/topic/5024/5024662.xml?temp=.7404596
[http_community.csdn.net_Expert_topic_4944_4944630.xml_temp_.8225672]: http://community.csdn.net/Expert/topic/4944/4944630.xml?temp=.8225672
[http_community.csdn.net_Expert_topic_4919_4919937.xml_temp_.2461359]: http://community.csdn.net/Expert/topic/4919/4919937.xml?temp=.2461359
[http_community.csdn.net_Expert_topic_4906_4906691.xml_temp_.1377222]: http://community.csdn.net/Expert/topic/4906/4906691.xml?temp=.1377222
[http_community.csdn.net_Expert_topic_4917_4917015.xml_temp_.7591364]: http://community.csdn.net/Expert/topic/4917/4917015.xml?temp=.7591364
[http_faq.csdn.net_FAQUnfurl.aspx_id_214875]: http://faq.csdn.net/FAQUnfurl.aspx?id=214875
[http_community.csdn.net_Expert_topic_4712_4712570.xml_temp_.3942224]: http://community.csdn.net/Expert/topic/4712/4712570.xml?temp=.3942224
[http_community.csdn.net_Expert_topic_5045_5045602.xml_temp_.0278284]: http://community.csdn.net/Expert/topic/5045/5045602.xml?temp=.0278284
[http_community.csdn.net_Expert_topic_4939_4939026.xml_temp_.4465296]: http://community.csdn.net/Expert/topic/4939/4939026.xml?temp=.4465296
[http_community.csdn.net_Expert_topic_4973_4973969.xml_temp_.4392816]: http://community.csdn.net/Expert/topic/4973/4973969.xml?temp=.4392816
[http_community.csdn.net_Expert_topic_4906_4906039.xml_temp_.6642267]: http://community.csdn.net/Expert/topic/4906/4906039.xml?temp=.6642267
[http_community.csdn.net_Expert_topic_5031_5031048.xml_temp_1.302737E-02]: http://community.csdn.net/Expert/topic/5031/5031048.xml?temp=1.302737E-02
[http_community.csdn.net_Expert_topic_5002_5002120.xml_temp_.4375727]: http://community.csdn.net/Expert/topic/5002/5002120.xml?temp=.4375727
[http_community.csdn.net_Expert_topic_5086_5086098.xml_temp_.6402094]: http://community.csdn.net/Expert/topic/5086/5086098.xml?temp=.6402094
[http_community.csdn.net_Expert_topic_4940_4940738.xml_temp_.8665125]: http://community.csdn.net/Expert/topic/4940/4940738.xml?temp=.8665125
[http_community.csdn.net_Expert_topic_4938_4938969.xml_temp_1.918972E-03]: http://community.csdn.net/Expert/topic/4938/4938969.xml?temp=1.918972E-03
[http_community.csdn.net_Expert_topic_4892_4892120.xml_temp_.1775324]: http://community.csdn.net/Expert/topic/4892/4892120.xml?temp=.1775324
[http_community.csdn.net_Expert_topic_4929_4929620.xml_temp_.2570154]: http://community.csdn.net/Expert/topic/4929/4929620.xml?temp=.2570154
[http_community.csdn.net_Expert_topic_5070_5070623.xml_temp_6.957644E-02]: http://community.csdn.net/Expert/topic/5070/5070623.xml?temp=6.957644E-02
[http_faq.csdn.net_FAQUnfurl.aspx_id_215243]: http://faq.csdn.net/FAQUnfurl.aspx?id=215243
[http_community.csdn.net_Expert_topic_5046_5046974.xml_tep_.9785425]: http://community.csdn.net/Expert/topic/5046/5046974.xml?tep=.9785425
[http_blog.csdn.net_dutguoyi_archive_2006_10_16_1337274.aspx]: http://blog.csdn.net/dutguoyi/archive/2006/10/16/1337274.aspx
[http_community.csdn.net_Expert_topic_5041_5041228.xml_temp_.8233911]: http://community.csdn.net/Expert/topic/5041/5041228.xml?temp=.8233911
[http_community.csdn.net_Expert_topic_5019_5019542.xml_temp_2.604312E-02]: http://community.csdn.net/Expert/topic/5019/5019542.xml?temp=2.604312E-02
[http_support.microsoft.com_kb_320125]: http://support.microsoft.com/kb/320125
[http_fufun.cn_show.aspx_id_dC8yMDAyMDUzMC8xNS83NjUxOTEuaHRtbA_x003D_x003D]: http://fufun.cn/show.aspx?id=dC8yMDAyMDUzMC8xNS83NjUxOTEuaHRtbA_x003D__x003D
[http_community.csdn.net_Expert_topic_5100_5100692.xml_temp_.0559656]: http://community.csdn.net/Expert/topic/5100/5100692.xml?temp=.0559656
[http_community.csdn.net_Expert_topic_5105_5105613.xml_temp_.3277399]: http://community.csdn.net/Expert/topic/5105/5105613.xml?temp=.3277399
[http_community.csdn.net_Expert_topic_5086_5086098.xml_temp_.5973932]: http://community.csdn.net/Expert/topic/5086/5086098.xml?temp=.5973932
[http_dev.csdn.net_author_taito_840c28a03ec0432492db18a329125bb5.html]: http://dev.csdn.net/author/taito/840c28a03ec0432492db18a329125bb5.html
[http_community.csdn.net_Expert_topic_4954_4954820.xml_temp_.495083]: http://community.csdn.net/Expert/topic/4954/4954820.xml?temp=.495083
[http_community.csdn.net_Expert_topic_4905_4905590.xml_temp_6.176394E-02]: http://community.csdn.net/Expert/topic/4905/4905590.xml?temp=6.176394E-02
[http_topic.csdn.net_t_20031203_09_2521118.html]: http://topic.csdn.net/t/20031203/09/2521118.html
[http_topic.csdn.net_t_20030407_11_1627991.html]: http://topic.csdn.net/t/20030407/11/1627991.html
[http_www.21cnvip.com_csdn_default.aspx_q_20021105_10_1149089.html]: http://www.21cnvip.com/csdn/default.aspx?q=20021105/10/1149089.html
[http_search.csdn.net_search_null_1_dev]: http://search.csdn.net/search/null/1/dev/
[http_community.csdn.net_Expert_topic_5004_5004254.xml_temp_.1570246]: http://community.csdn.net/Expert/topic/5004/5004254.xml?temp=.1570246
[http_community.csdn.net_Expert_topic_4682_4682496.xml_temp_.6038324]: http://community.csdn.net/Expert/topic/4682/4682496.xml?temp=.6038324
[http_community.csdn.net_Expert_topic_4835_4835266.xml_temp_.7495233]: http://community.csdn.net/Expert/topic/4835/4835266.xml?temp=.7495233
[http_community.csdn.net_Expert_topic_5006_5006594.xml_temp_.2426111]: http://community.csdn.net/Expert/topic/5006/5006594.xml?temp=.2426111
[http_community.csdn.net_Expert_topic_4951_4951804.xml_temp_.2144739]: http://community.csdn.net/Expert/topic/4951/4951804.xml?temp=.2144739
[http_community.csdn.net_Expert_topic_5089_5089204.xml_temp_.4461328]: http://community.csdn.net/Expert/topic/5089/5089204.xml?temp=.4461328
[http_community.csdn.net_Expert_topic_5092_5092752.xml_temp_.8595545]: http://community.csdn.net/Expert/topic/5092/5092752.xml?temp=.8595545
[http_blog.csai.cn_user1_19065_archives_2006_8916.html]: http://blog.csai.cn/user1/19065/archives/2006/8916.html