>I just discovered the awesomeness that is SQL Bulk Insert. In theory I can use that to create a stored procedure to load a table from a file.
>
>Now I'm wondering if there is a way to extract from a view to a flat data file from a query also. Anybody have any examples?

Look at DTS and/or BCP.