CODEWITHSUNDEEP
sqlsql-serversql-server-express
user300981
user300981

Reputation: 1433

Data Import in SQL Server Express

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.

Upvotes: 0

Views: 682

Answers (2)

Dustin Laine
Dustin Laine

Reputation: 38503

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

Upvotes: 1

user183402
user183402

Reputation:

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.

Upvotes: 1

Related Questions