Import files (csv, text and spreadsheet xls) into Microsoft Access

In the scenario where one needs to consolidate sales figures from different distributors where data feeds from each distributors differ from one another, the below approach using off the shelf Microsoft Access is possible.

1. Import Feeds into MS Access Tables using compiling tool (Names of source files will be added as a field)

2. Uses UNION ALL Query (SQL) to consolidate all the required fields from the respective tables into one main data source for analysis (Need to analyse the data structure of feeds from the respective Distributors ~ to know which fields are relevant for extracting.

COMPILING TOOL as per below attached: For importing data feeds into ACCESS (allows for CSV , Txt and spreadsheet formats)

Function:

1. Browse and select folder where all the files reside (Need to Specify File Type )

2. Files imported will be archived in a Archive Folder in that directory

3. As all files in Folder must be of the same type, its suggested to organise and structure the folders of data feeds by Distributor Name as per below

User Interface of Compiling tool

 Browse and select folder >>> Select File type of data feeds residing in the selected folder >>> Click Import

DOWNLOAD FILE