File Format
Posted: Wed Dec 09, 2009 10:10 am
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?
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?