Import sqlsever and excelsqlsever in excel
Now we usually add some data to the database when testing the software. If the amount of required data is small, it is easy to say, but it will be too slow to add multiple entries, in fact, we can download the existing data from the Internet and import it to the database. because some existing data on the Internet is in excel format, we need to know how to import excel to sqlsever.
① Select the database for which you want to import data, and right-click "task" --- "import data ".
② Next step
③ Select excel as the data source, and then select the file path. Next Step
④ Select the target database to which you want to copy the data and click Next.
⑤ If your excel Field is the same as the database table field, click Next. Otherwise, select "Write query to specify the data to be transmitted"
⑥ Select the table to be copied and the table in the corresponding database in "target". Next
7. Next, import is successful.
Check the effect!
You can also manually add so much data, data import, and efficient work!
Here we will not only talk about excel. If you want to take the data from another database table and use it directly, you can choose a variety of data sources and a variety of Database options, not only is it limited to the local machine, but more tips for convenient work will be introduced later. Please keep an eye on my blog. There are many benefits!