Using a text file as a datasource with spaces in the column names.
Posted on 2006-06-28
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?