Access File Import (Class Module)
Access import module that makes the the improt process an object, with parameters for the following:
Properties
- Staging Table
- Master Table
- Report Data value (process creates this and requires it)
- Null Check Filed (for removing empty rows)
- Source Path
- Import Type (TransferSpreadsheet (XLS), TransferText (CSV), and and XLW-type module using ADO (ADO)
- Tab Name (if necessary)
- Start Line (if using ADO)
Methods
- Create method for creating necessary staging and master tables
- Import method for importing data
Right-click to Save Target As: CImportObject.cls