[ic] Why the """"too many quotes""""

[interchange-users@icdevgroup.org (Mike Heins)]

Quoting Grant (listbox@email.com):
> 
> >> >> I ran into a little issue.  Some of my tables had populations
> >> >> with "quotes"
> >> >> around the items.  I deleted all that I could find.
> >> >
> >> > Did you edit your table in Excel?
> >> >
> >> > Rene
> >> >
> >>
> >> Yes, I did.  What can I do?  I can't see the quotes in the table (using
> >> bbedit (UNIX settings).  Now What?
> >
> >I would say that Excel screws somehow up your data. Check the file you
> >upload to IC that it is without the """" quotes. Try to export the file as
> >tab-delimited, and not comma-separated.
> >
> >Rene
> 
> Excel definitely adds those quotes.  When I ran into that problem I looked
> through the Excel docs and didn't think there was a way around it with the
> way I needed it done.  What I ended up doing was saving the file as XLS,
> importing into Access, and then exporting to txt.  Access doesn't add those
> quotes.  Someone else on the list suggested I do that, and thanks again to
> whoever that was.
> 

I believe 

    Database products EXCEL 1

still works.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

I don't want to get to the end of my life and find I have just
lived the length of it. I want to have lived the width of it as
well. -- Diane Ackerman