This works of course (and I hadn't thought of it, honestly) but on wide tables (lots of columns) UPDATE isn't fun to type.
David On 10/22/05, Kurt Welgehausen <[EMAIL PROTECTED]> wrote: > If you want all the empty fields to be null, why not > just set them, with a single sql statement (per > affected column), after the import? > > Regards > -- David Finlayson Marine Geology & Geophysics School of Oceanography Box 357940 University of Washington Seattle, WA 98195-7940 USA Office: Marine Sciences Building, Room 112 Phone: (206) 616-9407 Web: http://students.washington.edu/dfinlays
