Skip to content
+1-888-319-3663

COMMUNITY FORUM

ODBC connection to text file

Julie S asked 8 years ago
Hello,

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?
Answers
Best Answer
lorren answered 8 years ago
Julie,

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.

Thanks

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