Skip to content


ODBC connection to text file

Julie S asked 10 years ago

About a year ago I set up a mapping using a text file as my source.  Now I need to change the path and I can't figure out what I did.

I used an ODBC connection as the Data Source.   Then in my connection string I connected to a text file with a UNC path. 

Once connected I run a query against the file. 

I can't figure out how I set this connection up to a UNC path. 

Can anyone help?
Best Answer
lorren answered 10 years ago

When you select the Text File Connection type, uncheck the "Use Current Directory" option and then click the Select Directory button.

In the Select Directory window, in the upper left hand corner, enter the UNC path and then you should be able to click OK.


If you would like to submit an answer or comment, please sign in to the eOne portal.