Back

Explore Courses Blog Tutorials Interview Questions
0 votes
3 views
in SQL by (6.1k points)
edited by

I have the data in an Excel sheet - actually it's in xlsx format, since it is now 2020. My requirement is to get this data into the SQL Server as following:

  1. I want it ad hoc, along with the use case being fed to tables with the test data, or as not so frequent data loads of small amount (e.g., less than 3k rows)

  2. I also want it in a robust, repeatable, and possibly in an automated way for a production system.

1 Answer

0 votes
by (12.7k points)
edited by

1.Open SQL Server Management Studio and hook up with your SQL Server database.

2.Expand the Databases and therefore the Tables folders for the table where you'd wish to insert your data from Excel.

image

3.Right-click the table and choose the fourth option – Edit Top 200 Rows.

image

4.The data are going to be loaded and you'll see the primary 200 rows of knowledge within the table.

image

5.Switch to Excel and choose the rows and columns to insert from Excel to SQL Server. Right-click the chosen cells and choose Copy.

image

6.Switch back to SQL Server Management Studio and scroll right down to the last row at rock bottom and locate the row with a star within the left-most column.

image

7.Right-click the star within the column header and choose Paste.

image

8.Your data from the Excel is now pasted into your table in the SQL Server

If you want to learn more about SQL, Check out this SQL training online by Intellipaat.

Related questions

0 votes
1 answer
0 votes
1 answer
asked Sep 6, 2019 in SQL by Sammy (47.6k points)
0 votes
1 answer
asked Mar 21, 2021 in Python by laddulakshana (12.7k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.5k questions

29.9k answers

500 comments

99.1k users

Browse Categories

...