Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged load

« Prev 1 Next »
  1. FAV

    Import data from tab - delimited datafile to SQL table.

    Fields are tab delimited and need to match table schema. I've found the tab separator ASCII(009) preferable over using a comma. The second version can help remove double quotation marks around character fields. Don't forget the keyword LOC...
    SQL 1 views posted 11 years ago by RICHARDP
« Prev 1 Next »