Software
Novice CSV Loader
A Windows utility for appending CSV and other delimited files to existing SQL Server tables.
- Platform
- Windows (64-bit)
Novice CSV Loader handles the file-to-database step: choose the source files, review the column mappings, and append their records to an existing SQL Server table.
What it does
- Select a source folder and filename pattern, then review the matching files before loading.
- Read a representative header and match source fields to the destination table's writable columns.
- Resolve columns by header name for each file, even when column order changes.
- Configure delimiters, encoding, quoted fields, header preambles, and empty-field handling.
- Choose how missing source columns and extra columns should be handled.
- Include generated metadata such as filenames, file identifiers, run identifiers, and timestamps.
A reviewed, one-time setup
Set up the next import without maintaining a job database or saved profiles. Connection strings, mappings, application settings, and run logs are not saved automatically. Reset clears the current setup and results without changing SQL data.
A typical import
- Choose the folder, filename pattern, and parsing options. Read a representative file's header.
- Connect to SQL Server and select the existing destination table.
- Review the source-to-destination mappings, optional columns, and generated metadata.
- Run the import, inspect the results, and verify the destination data.
Know before you load
Imports are append-only. The loader does not create, alter, clear, or replace destination tables, and it does not remove existing rows. Prepare the destination schema and use an account with the appropriate database permissions.
An import is not one all-or-nothing transaction. Completed SQL batches remain after an error or cancellation; an interrupted batch can have an uncertain partial result. Verify the destination before running the same files again, because a repeated load can append duplicate records.
Platform
A 64-bit Windows desktop application for Microsoft SQL Server. The destination table must already exist, and data must fit its column types, defaults, and constraints.
Availability and help
To ask about Novice CSV Loader or discuss a data import, email info@noviceacressystems.com.
If the source data needs cleansing, transformation, or preparation before loading, Acres DataWorks provides those services through Novice Acres Systems.
