Loader
Answers to frequently asked questions about the file loader.
- How do I load a file with fields in a different order to columns in my table?
- How do I load a file with more fields than columns in my table?
- How do I load a file with less fields than columns in my table?
- How do I load a file with a field delimiter other than a comma?
- How can I skip header records?
- How do I ignore empty lines?
- How can I ignore extraneous carriage return characters?
- Are quotation marks optional around text fields?
- How do I define a tab as a field delimiter?
- How can I skip comment records?
- How do I load only records of a certain type?
- How do I only commit data at the end of a file load?
- How do I load a timestamp which contains no spaces or formatting?
- How can I handle a file with fixed width fields?
- How do I handle embedded control characters?
- How can I handle unmatched quotation marks?
- Can I use a control file to define my load switches?