• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

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

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

0
fly412s
Asked:
fly412s
1 Solution
 
dstanley9Commented:
try

"SELECT [Task ID] from [" + text file + "]"
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now