Re: Fixed width alternative to TEXT type field?

2002-09-27 Thread Gary Traffanstedt
On Thursday 26 September 2002 11:16 pm, Jeremy Zawodny scribbled something about: On Thu, Sep 26, 2002 at 11:24:14AM -0700, Gary Traffanstedt wrote: sql,query I have a table that has approximately 40 colums and all but 1 of them I have been able to make fixed width. The sole hold out

Re: Importing fixed-width delimited large text files?

2001-11-01 Thread Carl Troein
Damned filter. Anything quoted once is my post. Grrr... database,sql,query,table Erica Douglass writes: I have a text file that is fixed-width delimited (that is, fields are delimited by certain column widths.) What is the workaround for this? Will importing large files work if I

Re: fixed width

2001-01-18 Thread Matt Wagner
phiLLip maDDux II writes: Hello, I am working on loading data into a table from a text file. I've read the documentation on the LOAD DATA command. But I noticed that it only works with some kind of delimited file. Is there any way to load a fixed width file??? Hi! Unfortunately