Import Text File Data Into Access
Load a delimited text file into Microsoft Access and review the basic Visual Importer ETL import flow.
Delimited filesVisual Importer ETL Tutorials
Video tutorials for delimited file imports, Automap, date fields, pivot-table imports, and import screen setup.
Start with the delimited-file import tutorial if you are new to Visual Importer ETL. If you already know the product, jump to Automap, date fields, pivot-table imports, or the import screen overview.
Visual Importer ETL Was Our First Software Product
Visual Importer ETL was the first software product we created. Advanced ETL Processor was designed later, is fully compatible with Visual Importer ETL, and has more features.
Most Advanced ETL Processor videos are relevant to Visual Importer ETL too, except videos that focus specifically on transformations.
Recommended Learning Order
Working With Automap Dialogue
Use Automap to match source and target fields faster when building repeatable import definitions.
Field mappingWorking With Date Fields
Handle date values during imports so source data lands in the target database with the expected format.
Date handlingImport Data From A Pivot Table
Import data from a pivot-table style source into a database when source layout is not a simple flat file.
Pivot tablesImport Screen Overview
Review the import screen and learn where common import settings are configured.
Interface overviewWhat These Tutorials Cover
Import setup
Create imports from files into databases and understand the main import-screen settings.
Source-to-target mapping
Use Automap and field mapping features to reduce manual setup work in repeatable imports.
Date handling
Control how date values are interpreted and loaded when source files use different formats.
Non-standard layouts
Import source data from pivot-table layouts when the data is not arranged as a simple row-by-row file.
Need The Product First?
Download the Visual Importer ETL trial before following the tutorials.