ASP.NET, SQL Server, WPF, C#, VB.NET

Dear all, 
 
By using TransferText Action running inside the macro, the text file will 
 
have text qualifiers like this: 
 
"7412","000000","000000000","7612","29000","100","100","0000","000000","00000",0.00,0.00,5246380.38,0.00,"","",0,"" 
 
Is it possible to elimiate those text qualifiers like this? 
 
7412,000000,000000000,7612,29000,100,100,0000,000000,00000,0.00,0.00,5246380.38,0.00,,,0.00, 
 
Thx for yr help!

Florence, 
 
First, run through the export manually, via the File|Export menu.  You 
 
can specify the qualifier to use (or none).  When you get to the final 
 
screen of the export wizard, click the Advanced button, and save your 
 
setup as a Specification.  Then, nominate this Specification in the 
 
arguments of the TransferText action in your macro. 
 
-- 
 
Steve Schapel, Microsoft Access MVP 
 
Florence wrote:

Florence, 
 
Yes, "text files" is correct. 
 
1.  Select the table or query in the Database Window. 
 
2.  Go to the File|Export menu. 
 
3.  Select the location, and "text files" as you suggested. 
 
4.  Click 'Export' (bottom right). 
 
THis takes you into the Export Wizard.  The 'Advanced' button is at the 
 
bottom left of this dialog window.  But go through the wizard with setup 
 
of deloimiters, qualifiers, etc, before going to 'Advanced'. 
 
-- 
 
Steve Schapel, Microsoft Access MVP 
 
Florence wrote:

Florence, 
 
On the "Export to..." window, untick the 'save formatted' checkbox. 
 
-- 
 
Steve Schapel, Microsoft Access MVP 
 
Florence wrote: