T-SQL way to export from SQL table to .csv/.xlsx ?
Posted on 2013-01-24
Question: Is there a T-SQL way to export data from a SQL table to a .csv or .xlsx?
I'm familiar with SSIS, but would like to avoid the work and overhead if that is possible.
I have an Access 2010 FE / SQL 2008 R2 backend, and the backend contains a table that is too wide to be linked to Access, so afaik I can't take advantage of Access' export specs.
Ultimately I'll have an Access form that allows a user to choose between different exports, then Access VBA will execute a Stored Procedure that populates the table with data. I just need to figure out how to build the piece that exports it.
Thanks in advance.