Microsoft SQL Server Management studio express import data! It's express!

Source: Internet
Author: User
Tags management studio microsoft sql server management studio sql server management sql server management studio

 

My machine is sql2005 installed with vs2005, and then download SQL Server Management studio Express on Microsoft's website, and I only found the Express version, this version does not directly provide the data import function. I have checked many posts on the Internet, all of which are about SQL Server Management Studio Enterprise Edition. I have nothing to say about the imported data, just do what you want, but there is no one talking about the Express version. After a long time, I did not find that this version can import the data. Later I found that it can also be implemented. The following is an example.

For example, I want to import data from access to SQL Server Management studio Express.

1. Create an ODBC Data Source pointing to the data you want to import. For example, if you want to import data to mydata of sql2005, create an SQL server data source in ODBC manager and give the data source name as needed, for example, enter your own server name for the mydatadns server.

Follow the prompts.

2. Open the access file you want to import, select the table file you want to export, right-click the pop-up menu and choose export. A window will pop up.


Select "ODBC database ()" at the bottom, OK.

Open your sql2005 and check if the table is already in it. This method is very convenient and is suitable for users who have not installed the Enterprise Edition manager.

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.