Import data from tab - delimited datafile to SQL table.


/ Published in: SQL
Save to your folder(s)

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 LOCAL.

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.