Regarding: I want to use .import ... but the first line is the variable(fields), so I want to ignore it. =================================
Possible option #1: If it wouldn't violate any database-enforced constraints, why not import the entire file, then delete the first row via SQL? DELETE FROM mytable WHERE ROW_ID=1; Possible option #2: Are you using windows? If not, and if you weren't using SED in a piped command (i.e., if you were copying the data via SED to a new file), then changing to a piped command might lessen the time. (Under windows, I believe a full file copy to a temporary file occurs with piped commands, so I would expect no advantage.) Possible option #3: You could instead modify the source of the command-line tool, of course. Donald Griggs Opinions are not necessarily those of Misys Healthcare Systems nor its board of directors.
