Mailing List Archive


Back to the month index Back to the list index
Aibek Musaev (abbey@cc.gatech.edu)
Sun, 2 Nov 1997 13:03:45 -0500 

From: "Aibek Musaev" <abbey@cc.gatech.edu>
Subject: msqlimport problem
Date: Sun, 2 Nov 1997 13:03:45 -0500
Message-ID: <01bce7b9$a9889d80$30403d80@r64h48.res.gatech.edu>

I have problems with importing ASCII formatted files. I have mSQL
server version 2.0.3. I use msqlimport:
msqlimport -s\| database table < filename
i.e. '|' as delimeter.

This works for tables that have short fields. However, when I try to
import tables with long fields ( ~ 3 kb long; I define them as
TEXT(255) ), msqlimport tells me:

Importing into table 'rl_essays'
Field 1 is 'classID' of type char
...
Field 18 is 'essayDetails' of type text

.Fatal error at line 1 : Invalid number of data fields for specified
table

I checked the number of my data fields and it is correct. It worked
well with the beta version of mSQL server before. What went wrong?
And how can I still import my ASCII files now?

Thanks in advance,
Aibek.