Is there any body out there to help me.. I have a Problem in Connecting to a Text Database Using ODBC


The Cooection String I used is

"Provider=MSDASQL;Driver={Microsoft Text Driver(*.txt;*.csv)};DBQ=E:\D999\;"


where I have all my text files in my E:\D999\ directory.

But when I tried to Open the Connection
it says "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

Please help me to Solve this ,its Very Urgent ...