Is there an equivalent in SQL Server to Access' exporting functions?
I am converting an Access database to SQL Server. One of the features of this Access DB is that it has a form through which you can export specific table data as a tab-delimited text file, csv or an excel format.
To make matters worse, the data that I want to export comes from several tables that I have merged into a view. ie. I want to export the values returned by a SELECT * on the view.
I am a newbie to Access and SQL Server so I don't know the ins and outs of things. It looks like DTS may be able to do what I want, but I am not sure. Any thoughts/ideas?