Remove Text Qualifier " from Text File via VBA code

S

ssh

New Member
Joined
Dec 12, 2005
Messages
34
Hi,
I have a line of code that takes my query and exports it into a text file. I need to have the double quotes around my data removed in the text file. What code do I need to add to accomplish this?

DoCmd.TransferText acExportDelim, , "qry_MRN_12", "G:\WLM\mrn_test.txt", False

The reason why I have to remove the double quotes is so that the data can be imported into another (unsophisticated) program that my company uses that does not allow you to remove text qualifiers.

I also don't want to export the text file manually (i.e., File, Export, Save as Text File, Text Qualifier = None, etc...) because I don't trust my endusers to remember to do this step.

Thank you for your assistance!
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
The key is to create an Export Specification that you can re-use. This is pretty easy.

Just go through a manual export once, and be sure to set the Text Qualifier option to "None". Then, just before you click Finish to actually export the file, click the Advanced button, then click "Save As" and give this Export Specification a name.

Then, in the TransferText command, their is an Export Specification argument. Simply add the name of your saved Export Specification there.

If you are unsure where that resides, you can create the TransferText command in a Macro, and then use the "Convert Macros to Visual Basic" functionality.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Access exporting text files with variable file names
Replies
5
Views
943
Micron
M
Anigito
  • Solved
MS Access Union Query Changes Numeric values to Text values
2
Replies
11
Views
827
Anigito
Anigito
T
  • Solved
Problem suppressing the printing of Access report (from Excel)
Replies
7
Views
2K
Micron
M
A
  • Solved
vba - Text Reader class
2 3
Replies
21
Views
2K
GWteB
GWteB
S
  • Question
Generate an XML file from a table via VBA
Replies
0
Views
166
Stez84
S

Forum statistics

Threads
1,214,643
Messages
6,120,702
Members
448,980
Latest member
CarlosWin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top