Skip to content

AutoUpdatingBSoD/FOSS-MSAccess-Conversion-Tool

Repository files navigation

FOSS-MSAccess-Conversion-Tool

Free and Open Source Microsoft Access File Conversion Tool

                                README                                     

  • 09/13/2019
  • Free and Open Source Software for MicroSoft Access File Conversion
  • FOSMSACT

                                 ABOUT                                     

  • This program is designed to convert between MicroSoft Access files and LibreOffice-readable file formats. These include but are not limited to

            - .csv
            - .txt
    
  • This program can be executed from the CLI (Command-Line Interface).

  • This application relies heavily on the Jackcess API, whose link is provided below:

  • This project (technically) lets you view your ACCDB files. Just run in verbose mode and the terminal will spit out the contents of your files.


                               PREREQUISITES                               

  • Installed Programs:
    • Java Ver. 8+. It does not matter who published it (i.e. both OpenJDK and Oracle Java worked for me).

                             INSTALL AND RUN                               

  • Installation Steps:
    - Install prerequisite programs with your OS's installation
    schema (e.g. sudo pacman -S java). (Note: for compatibility reasons, required Java Libraries are included) - Compile the code with: javac -cp ".:jackcess-3.0.1.jar:commons-lang3-3.9.jar:commons-logging-1.2:commons-logging-1.2.jar:poi-4.0.0:poi-4.0.0.jar" FOSMSACT.java

  • To Run:
    - Run the code with: java -cp ".:jackcess-3.0.1.jar:commons-lang3-3.9.jar:commons-logging-1.2:commons-logging-1.2.jar:poi-4.0.0:poi-4.0.0.jar;" FOSMSACT

            CLI PARAMETERS:
                [-h || --help        ] if you need help.
                [-i || --input       ] input filename            (REQUIRED)
                [-o || --output      ] output filename           (REQUIRED)
                [-r || --revisionnum ] MS Access Revision        (will default to 2016 if not specified)
                [-v || --verbose     ] Print file contents
    

                                  NOTES