By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

help me

P: 3
Hi ,
I want to export a query to text file by code, i use tesxttransfer method but in my output text file the fields are seprated by comma , how i can eliminate these commas by code.
note that fielda are number.
regards
Feb 4 '08 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi ,
I want to export a query to text file by code, i use tesxttransfer method but in my output text file the fields are seprated by comma , how i can eliminate these commas by code.
note that fielda are number.
regards
Set up an export specification by manually exporting the query. Choose to export a fixed length text file instead of comma separated and choose the advanced option on following window to save the export specification "myexportspec". Then use this specification in the textTransfer method.
Feb 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.