Is that anyway to reset the Text qualifier from " to '

P

Peter Chin

Dear all MVPS,

I need the advice on the way to reset the default text qualifier in the
export specification
screen from double quote " " to single quote ' '.

Thanks

Peter
 
6

'69 Camaro

Hi, Peter.
I need the advice on the way to reset the default text qualifier in the
export specification
screen from double quote " " to single quote ' '.
Click to expand...

When you export to the text file manually, the Export Text Wizard appears.
Press the "Advanced..." button to open the Export Specification dialog
window. Up at the top is a combo box labeled "Text Qualifier." Change it
from " to ' and then save this as a specification by pressing the "Save As"
button and naming your specification.

Next time you use the Export Text Wizard, you can again apply this rule by
pressing the "Advanced..." button to open the Export Specification dialog
window, then pressing the "Specs" button and selecting this specification.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
P

Peter Chin

Peter Chin said:
Dear all MVPS,

I need the advice on the way to reset the default text qualifier in the
export specification
screen from double quote " " to single quote ' '.

Thanks

Peter
Click to expand...
 
J

John W. Vinson

Yes, it is possible. This question was answered, perhaps you did not
get the answer in the newsgroup.

Use the "Advanced" button on the export wizard, and choose ' as a
delimiter.

John W. Vinson [MVP]
 
Top