Data Import in SQL Server Express

Question

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.

Answer 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.

Answer 2

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