Can't open txt files in a sql based app.

Looking for help for SQL2008 so that an app I am using can connect to SQL db as well as access data in csv text files. Do I need to change them to excel files? is that the only way?