Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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