Saving file as Tab Delimited

[Hermie]

I am trying to save an Excel file as Tab Delimited, so
that I can import it into a database, but it is not saving
it the way I want it.

I need one field to save the data with the quotation
marks, but whenever I save it with the quotation marks, it
adds more quotation marks. Specifically it adds two more
on each side.

I enter "Microsoft High", but the saved file
shows """Microsoft High""".

What's going on?

 

[David McRitchie]

The CSV file will generate the quotes as needed most programs on
PCs will use what they see between delimiting commas.
The doublequotes are used if the data contains a delimiter (comma)
and if the data contains double quote as you have created then
the field is enclosed in double quotes and the internal double quotes
are doubled, this makes parsing possible by most programs
that know the rules...

 

[Dave Peterson]

You could write a macro that does exactly what you want.

Here's a couple of links that may give you an idea:

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

Earl Kiosterud's:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(I think Earl's may have options that do what you want.)