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 »