[ic] IC - tab-delimited text and Excel

DB interchange-users@interchange.redhat.com
Sat Jan 19 11:02:00 2002


I have IC 4.8.3 running with MySQL under Red Hat 7.1. All is well except 
for Excel goofing up my tab delimited products file. As is known, Excel 
adds quotation marks and carriage returns to text fields in certain 
cases. I'm using Excel XP by the way.

I read the docs and list archives and got some suggestions. First it 
said to use "none" as the text qualifier in Excel when opening the text 
file, which I did. I also added the line
  Database products EXCEL 1
to my catalog.cfg file. But I'm still having trouble.

I can't just strip all quotation marks from the text file because many 
of my products use the quotation in the description to mean inches.

I use Excel because my products database is rather large, say 50,000 
items. QuattroPro is VERY slow on files this large. Maybe I should try 
StarOffice? Can anyone help me solve this ?

Dave
M&D Mower
http://M-and-D.com