<div>
<div class="content wysiwyg-content">
How do I query the text file using a SELECT statement if the column names (headers) have spaces. &nbsp;For example, I want to select all task ID's from the text file. &nbsp;However, the column name is &quot;Task ID&quot;. &nbsp;The following statement will not work: &nbsp;&quot;SELECT Task ID from [&quot; + text file + &quot;]&quot;. &nbsp;Basically what I'm asking is how to use a Select SQL statement when the column names have spaces?<br />
<br />
Thank-you<br />
<br />

</div>
</div>


How do I query the text file using a SELECT statement if the column names (headers) have spaces.  For example, I want to select all task ID's from the text file.  However, the column name is "Task ID".  The following statement will not work:  "SELECT Task ID from [" + text file + "]".  Basically what I'm asking is how to use a Select SQL statement when the column names have spaces?

Thank-you



Using a text file as a datasource with spaces in the column names.

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).