Access VBA | Import Excel Tables to Access Pt. 1

Поделиться
HTML-код
  • Опубликовано: 21 окт 2024

Комментарии • 1

  • @VinodKumar-jv6mi
    @VinodKumar-jv6mi 2 года назад

    Hey alex please put a video regarding this please help me
    I am here by attaching the 2 files
    Bill of Quantity (BOQ) - That has the Sample Data - "Sample BOQ - IP Core - With Few Data.xlsx"
    Analysis & Structure derived from BOQ Ver 0.1.docx
    Objective : To convert the data available in Excel to the Structure mentioned in the Word doc. You can enhance the structure as per your convenience.
    For Sample I had given 1 file but in real scenario multiple files will be coming and we need to have provision to read the files in loop.
    Suggestion - Try to have configurations outside the programming logic
    Technology to be used : Use Python as Programming language
    Database to be used : Suggested SQL Server tables , Or access database