• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 402
  • Last Modified:

MS SQL Server Management Studio

Hello expert,

Need to do some joins on a table that is about 5k rows.
I have used MS SQL Server before but not for a while
So downloaded SQL Server Express.

Used to be there was an import data wizard to
bring in data from external sources. Can't find anything
like that in File, Edit, View Project, Debug, Tools, Windows, Help

All I want to do is import a spreadsheet. Where did the
Import Data Wizard go?

Thanks

Allen in Dallas

import Excel into SQL ServerSQl Server Manament StudioSQl Server Manament StudioSQl Server Manament Studio
0
Allen Pitts
Asked:
Allen Pitts
1 Solution
 
David KrollCommented:
Go to Tools -> External Tools.  Click Add, and enter the command C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\DTSWizard.exe.  Yours may be located elsewhere, just find DTSWizard.exe.  Give it whatever title you want (I use Import/Export Data).
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now