We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Load a file into a temporary database table
Reads an XML, tab-separated, or comma-separated file and inserts its contents into a temp table. For delimited files the first row must contain column names. Use quoting option 2 when tab-separated data has blank leading fields that the MS parser would otherwise truncate. File must be within a permitted folder.
| Parameter | Description |
|---|---|
| cmd | full path to the source file |
| Argument 0 | temp table name to create and populate |
| Argument 1 | file format: TAB, COMMA, or blank for XML |
| Argument 2 | DEBUG to enable row-by-row debug mode for diagnosing bad XML records |
| Argument 3 | quoting: 0 = data is not quoted, 1 = data is already quoted, 2 = quote data before parsing |
| Argument 4 | character encoding: utf8 (default) or ascii |
FileToTempTable "full path to the source file", "temp table name to create and populate", "file format: TAB, COMMA, or blank for XML", "DEBUG to enable row-by-row debug mode for diagnosing bad XML records", "quoting: 0 = data is not quoted, 1 = data is already quoted, 2 = quote data before parsing", "character encoding: utf8 (default) or ascii"