[AccessD] (OT) saving as *cvs with " "

See http://support.microsoft.com/?kbid=213448

Michael R. Mattys
Try MattysMapLib for MapPoint at
www.mattysconsulting.com



----- Original Message -----
From: <Oleg_123 at xuppa.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, January 15, 2004 3:15 PM
Subject: [AccessD] (OT) saving as *cvs with " "


> Hey Group
> i have to save this data (right now I have it in a spreadsheet)
> 01003, 011-11-1123, Doe, Jane, A
>
> as .txt file so it would like
>
> 01003, 011-11-1123, "Doe", "Jane", A
>
>
> and they specifically want quotes around first and last name, and ONLY
> there. when I create *.csv file from Excel I got no quotations (I tried
> specifically making those 2 fields as "text" and the others as "general"
> and even "numbers", but no result) When I do it through though Acess I get
> all in quotations, and over there I can't play with data types. I tried
> adding colums with " at the beginning and end of mane fields, but ehen I
> converted that to *.csv I got tripe quotes on names, and no quotes
> elsewhere...
> Any suggestions ?
>
>
>
>
> -----------------------------------------
> Get Breaking News from CNN, ABC, NBC, CBS Now.
> http://www.xuppa.com/news/?link=webmail
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>