Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2004

Tip: Looking for answers? Try searching our database.

CSV Save As Format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Clark Murray - 02 Apr 2004 22:23 GMT
Is there a csv (or txt) Save As format in Excel that exports all non-numeric fields in quotes (not just the ones with spaces and/or commas) like MS Access does.  I can't seem to find one.

Signature

Best Regards,
Clark Murray

Dave Peterson - 03 Apr 2004 00:34 GMT
Can you put the double quotes around numeric entries, too?

(It didn't bother excel when I re-imported, but it might make another program
burp.)

If yes, then maybe you could use a couple of helper cells:

I'd build a nice string in the first:

="@"&A1&"@,@"&B1&"@,@"&C1&"@"
(concatenates a1, b1, c1)

then use another formula that changes the @ to "'s.
=SUBSTITUTE(D1,"@","""")

Then I'd copy that column and paste into notepad and save from there.

You could write your own code if you wanted to:

I'd try to steal as much as possible from one of these samples:

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

(You may want to try Earl's.  It may be sufficient as is.)

> Clark Murray wrote:
>
[quoted text clipped - 5 lines]
> Best Regards,
> Clark Murray

Signature

Dave Peterson
ec35720@msn.com

Clark Murray - 03 Apr 2004 00:52 GMT
Thanks.  However, if there really isn't a format like this in Excel, it's
easier just to import the worksheet into Access and then re-export.

Signature

Best Regards,
Clark Murray

> Can you put the double quotes around numeric entries, too?
>
[quoted text clipped - 38 lines]
> > Best Regards,
> > Clark Murray
Dave Peterson - 03 Apr 2004 00:57 GMT
If you can't do it in excel, it ain't worth doing <vbg>.

I don't think that there's any built in way (in xl) of doing what you want.

> Thanks.  However, if there really isn't a format like this in Excel, it's
> easier just to import the worksheet into Access and then re-export.
[quoted text clipped - 52 lines]
> > Dave Peterson
> > ec35720@msn.com

Signature

Dave Peterson
ec35720@msn.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.