Solved

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

Posted on 2006-06-28
1
264 Views
Last Modified: 2010-04-16
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
Comment
Question by:fly412s
1 Comment
 
LVL 25

Accepted Solution

by:
dstanley9 earned 500 total points
ID: 17003534
try

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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Hey!! 5 37
Printing 1 58
Please explain the parts of these 2 LINQ expressions 3 54
C# Linq - Join two objects into one 3 14
We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question