This took an unfortunate amount of time to figure out, so here goes: 1) Using the command prompt (NOT THE QUERY WINDOW), type: bcp DatabaseName.TableName out nul -c -fTemplate.dat -Slocalhost\SQLEXPRESS -T 2) The result should be a file named Template.dat that will contain your column headers from that table. 3) Now using the command prompt type: bcp DatabaseName.TableName out D:\TableData.dat -c -fTemplate.dat -Slocalhost\SQLEXPRESS -T 4) The result should be a file named D:\TableData.dat that contains all of that table's data. Additional Notes: It turns out I was running an old version of BCP, which is why I could only use tab-delimited file formats and not XML (the -x parameter). More info here. To use XML, which is preferable, simply add the -x parameter to step 1. Currently upgrading to SQL 2008 Express to resolve the issue.