View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Get rid of quotation marks when importing

In your query include this parameter

..TextFileTextQualifier = xlTextQualifierDoubleQuote


"Lori" wrote:

I use excel to set up products that I then import to my web site. Many times
the item descriptions contain ". When I import these extra " are added and
show up on my website.

Anyone know how to keep this from happening? I'm using tab delimited.
--
Thanks :) Lori