Could not find installable ISAM when Filling Adapter

[Cimperiali]

[...]My Select statement needed brackets around the column names for some reason. The second error was that somehow it getting a C: in front of the whole path name so it might read something like this C:\F:\Filename. LOL. Wow 2 days just to find out it was my stupid formatting. Anyway thanks again Arjay and Cimperiali I really appreciate the advice and leads. Sorry Arjay if my comment seemed at all rude, I was not trying to be just a bit stressed after dealing with that for a couple days, I am sure you have been there.

brackets are usually needed when columns names are not well formed (for eaxmple, the are of two words with a space between) or could lead to a confusion (for example you give to a column the name of a reserved word, like "Connection"). Brakets make it clear to the sql engine that you're speaking of a column.
About your path

"Data Source=" + flePath + SLASH + fleName

may we know how flePath is filled?
usually you should do something like

string spathName=System.IO.Path.Combine(flePath,fleName);

and then use spathName.
To see where it is going while testing :

System.Diagnostic.Debug.Writeline(spathName);

About Arjay : he is the one who solved this. I simply found a way to make you try once again on connection string formattting. You should rate Arjay