This tutorial shows the basic Visual Importer ETL import flow: select a delimited file, map the fields, and insert the rows into Access.
What You Will Learn
- Create an import from a comma-delimited text file.
- Connect the import to a Microsoft Access target table.
- Review source-to-target mapping before loading the data.
- Run the import and check the inserted rows.
Before You Start
Have a sample delimited file and an Access database ready. Work with test data first. Production data has a habit of choosing the worst possible moment to be surprising.
Need Visual Importer ETL First?
Download the Visual Importer ETL trial before following the tutorial, or review the product page if you are comparing editions.