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.