0

SQL Server Express does not have the Tasks -> Import Data option that other editions of SQL Server has. Has anyone come across a free tool to import data?

I understand I can use the bulk import but I have run into a security issue with it and would like a quick and a dirty way of importing a csv file to a sql express table.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user300981
  • 1,423
  • 5
  • 13
  • 16
  • May be [SSMS: How to import (Copy/Paste) data from excel](https://stackoverflow.com/q/61012585/6165594) can help (If you don't want to use `BULK NSERT` or don't have permissions for it). – Denis Apr 08 '20 at 13:34

2 Answers2

1

If you download the SQL Server 2005 Toolkit add on, do a full instal of the components and you will get a free copy of the DTS Wizard, the equivalent of what came in other versions.

1

Check out this forum post, has two good solutions: http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/546f4407-0aa4-4b04-96f3-e6f0ba39a9d1/

BCP and Microsoft SQL Server 2005 Express Edition Toolkit

Dustin Laine
  • 37,935
  • 10
  • 86
  • 125