SQL data import and export problem summary

You can see many database connection methods by clicking this link. Http://www.connectionstrings.com/
The data exchange between these databases is the content to be summarized in this post.

(1) between SQL Server
Import data from the remote database to the local database.
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/4982/4982625.xml? Temp =. 8189966.

Import several tables and views in database a to database B.
Http://community.csdn.net/Expert/topic/5042/5042648.xml? Temp =. 2556574.

Importing the sql2005 database to SQL2000
Http://community.csdn.net/Expert/topic/4954/4954820.xml? Temp =. 3408625.
In sql2005, how does one Import Analysis Service in SQL2000?
Http://community.csdn.net/Expert/topic/4713/4713032.xml? Temp = 2.752322e-02

Chinese garbled characters exported by BCP in SQL server2005
Http://community.csdn.net/Expert/topic/5024/5024662.xml? Temp =. 7404596.

How to export a *. Bas file saved by SQL back to SQL
Http://community.csdn.net/Expert/topic/4944/4944630.xml? Temp =. 8225672.

(2) SQL Server --> access

Export SQL data to access (SQL and access are on the same machine)
Http://community.csdn.net/Expert/topic/4919/4919937.xml? Temp =. 2461359.
Export SQL data to access (SQL and access are not on the same machine)
Http://community.csdn.net/Expert/topic/4906/4906691.xml? Temp =. 1377222.
Http://community.csdn.net/Expert/topic/4917/4917015.xml? Temp =. 7591364.

(3) Access --> SQL Server
Http://faq.csdn.net/FAQUnfurl.aspx? Id = 214875

Why does the database structure change when access and sqlserver2000 are imported and exported? The default primary key is missing the automatic number?
Http://community.csdn.net/Expert/topic/4712/4712570.xml? Temp =. 3942224.

(4) txt (Notepad) --> SQL Server
Http://community.csdn.net/Expert/topic/5045/5045602.xml? Temp =. 0278284.
Garbled characters occur when importing TXT files to the database.
Http://community.csdn.net/Expert/topic/4939/4939026.xml? Temp =. 4465296.
About storing thousands of large texts in sqlserver
Http://community.csdn.net/Expert/topic/4973/4973969.xml? Temp =. 4392816.

(5) SQL Server --> txt
Http://community.csdn.net/Expert/topic/4906/4906039.xml? Temp =. 6642267.
SQL export txt or HTML Help
Http://community.csdn.net/Expert/topic/5031/5031048.xml? Temp = 1.302737e-02

(6) Excel --> SQL Server
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/4940/4940738.xml? Temp =. 8665125.
Http://community.csdn.net/Expert/topic/4938/4938969.xml? Temp = 1.918972e-03
Http://community.csdn.net/Expert/topic/4892/4892120.xml? Temp =. 1775324.
When using EXCEL to import databases, this strange problem occurs. When the data types in a column in Excel are obviously different, eof ,??
Http://community.csdn.net/Expert/topic/4929/4929620.xml? Temp =. 2570154.

(7) DBF --> SQL Server
Http://community.csdn.net/Expert/topic/5070/5070623.xml? Temp = 6.957644e-02

Other problems

How to export the questions in the database to the word Through VB
Http://faq.csdn.net/FAQUnfurl.aspx? Id = 215243

Use a job to complete DTS operations.
Http://community.csdn.net/Expert/topic/5046/5046974.xml? TEP =. 9785425

You can also see the link
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.

Oracle --> SQL Server
Http://community.csdn.net/Expert/topic/5019/5019542.xml? Temp = 2.604312e-02

Http://support.microsoft.com/kb/320125

Http://fufun.cn/show.aspx? Id = dc8ymdaymduzmc8xns83njuxoteuahrtba_x003d _ x003d _

The datetime format when using bulk insert to import data is incorrect,
Cause: bulk insert cannot convert the data type. If the time format is incorrect, an error occurs.
Http://community.csdn.net/Expert/topic/5100/5100692.xml? Temp =. 0559656.

Excel --> SQL Server
Add additional columns during import,
For example, execl table structure is name, content, category,
The sqlserver table structure is name, content, category, and attribute.
Http://community.csdn.net/Expert/topic/5105/5105613.xml? Temp =. 3277399.

Makeup
Excel --> SQL Server
Column name adjustment supplement during import
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://community.csdn.net/Expert/topic/4954/4954820.xml? Temp =. 495083.

SQL Server 2005 --> SQL Server 2000
Use the import and export tool of sql2005 to export all sql2005 tables and data to SQL2000, but all the primary keys, indexes, links, and default values are lost.
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/20030407/11/1627991.html

SQL Server --> DB2
Http://www.21cnvip.com/csdn/default.aspx? Q = 20021105/10/1149089.html

You can search for csdn at the following link.Technical CommunityDocumentation, a huge technical treasure.
Http://search.csdn.net/search/null/1/dev/

SQL Server 2000 --> SQL Server 7.0
When SQL2000 data is imported to sql7, those that are set as primary keys do not exist.
Http://community.csdn.net/Expert/topic/5004/5004254.xml? Temp =. 1570246.

SQL Server 2005 --> SQL Server 2000
Why is there always an error in the 2005 export script running at 2000?
Http://community.csdn.net/Expert/topic/4682/4682496.xml? Temp =. 6038324.

Copy databases between SQL servers
Http://community.csdn.net/Expert/topic/4835/4835266.xml? Temp =. 7495233.

SQL Server 2000 --> SQL Server 2000
Create a DTS package
Http://community.csdn.net/Expert/topic/5006/5006594.xml? Temp =. 2426111.

SQL Server 2005 --> Excel
Data Length: 255, error
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.

SQL Server 2000 --> SQL Server 2000
Export all table structures and Data
Http://community.csdn.net/Expert/topic/5092/5092752.xml? Temp =. 8595545.

Trackback: http://blog.csai.cn/user1/19065/archives/2006/8916.html