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

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License