Loading Data from Excel and Access Files

Advanced ETL Processor Reader Object is capable of extracting data from MS Excel 3.0-2007 files and MS Acess 4.0-2007 databases . In order to work with MS Office 2007 files please download Office 2007 Data Access Components

 To change Reader Object properties double click on it. Type in Description than select appropriate Data Source Type.

One of the benefits of using Advanced ETL Processor is ability to load several files/databases in one go. Provided that the files are in same format all you need to do is specify mask and they will be loaded automatically. It is also possible to select several tables as data source and  even specify a mask to find tables to load.

   

Data View

  Once all the parameters for the source file are set we can open it and see the actual data.

Data View Toolbar

1. Reader Properties
2. Refresh Data
3. Edit file in external editor
4. Switch to Data View
5. Switch to Data Definition View

Data Definition View

Data Definition View Toolbar

1. Reader Properties
2. Refresh Data
3. Print Data Definition
4. Print Preview Data Definition
5. Find
6. Edit file in external editor
7. Switch to Data View
8. Switch to Data Definition View

About Advanced ETL Processor

Advanced ETL Processor is a Codeless ETL Tool.
It is designed to automate extracting data from ANY database, transform, validate it and load into ANY database .

Users can create Data transformations and Sql scripts add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis

By combining simple Package actions together Advanced ETL Processor helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

Feel free to try Advanced ETL Processor today. All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

Watch Online Flash Demo
Download Advaced ETL Processor now