File Format

[wjfitzgerald]

Hi,

I am running a job which writes the results of an sql query to a tab delimited .txt file.

The file is then imported into a MS Access DB.

When i run the job with the file name set to A.txt, it all works fine.

I want to add the date to the file title to avoid overwritting the file (this is a daily scheduled process). so i changed the file name declaration to E:\IBM\A#DSJobStartDate#.txt.

The job runs to a clean completion, and on opening the text file everything looks good.

However when i import it into Access the the data appears as "獢湵彤慤湹९敬牴江牴慟慮ॴ敬牴慟歟祥氉瑥彲捯彳潣汬畱氉瑥彲摷瑡॥敲楶睥摟瑡॥慢慬据॥牡彲慤ॹ敬牴扟慲据२敬牴潟獣损獬慴ॴ敬牴潟獣灟楲牯氉瑥彲慣整潧祲氉瑥彲捯彳灢慲瑭਍㠰ㄯ⼲〲㤰匉". I changed the code page to UTF 8 and this made things marginally better but did not fix all the issues.

So here's my question, all i have changed is the file name and yet the definition of the file itself has changed, is there some way round this?