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...

 

[John Taylor]

Hi,

I'm not sure if it will help in your situation or not, but there is a
Microsoft Knowledgebase article, 123183 (Procedure to Export Text File with
Comma AND Quote Delimiter) that may do what you're attempting to achieve.

The summary states:

"Microsoft Excel does not have a menu command to automatically export data
to a text file so that the text file is exported with both quotation marks
and commas as delimiters. For example, there is no command to automatically
create a text file that contains the following:

"Text1","Text2","Text3"

However, you can create this functionality in Microsoft Excel by using a
Microsoft Visual Basic for Applications procedure."

HTH

Cheers,

John

 

[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.)