Search code examples
sql-serverssms

SQL Server Management Studio 18.0 missing Tasks option on right click

I installed SQL Server Management Studio 18.0... But missing Tasks option on right click... Need to Import Data from excel to Table

I have installed following:

SQL Server 2017

Sql Server Management Studio 18

SQL Server Data Tools - I don't know I need it or not but just installed it..

SQL Server Management Studi Right Click

Not sure what did I do wrong.

Another Image... Import Data Grayed out... Import Data Grayed Out

SSMS Version 15.0 SSMS Version 15.0 Info

Solution

  • You have to expand ( click the plus sign ) on databases and then right click on a particular database then to see tasks option.