Data Extraction from MS Access database on Windows 10 20H2 via script
Budget: $30 – $250 USD
I need data extracted from an MS Access 2007 (.mdb) used by ZKTeco, not all data are extracted, only select columns from different table.
What I require:
1. Script needs to be vbscript (text-based, executed by Windows cscript.exe).
2. Script should have option to fetch data based on specified date/hours/minutes at runtime.
3. Script should have option to specify the location of the database at runtime.
4. Script output is text-based (.csv).
5. Script is NOT obfuscated for checking and validation by IT Security group.
6. Script does NOT require custom app/3rd part apps to run. Should be running on built-in Windows 10 with NO helper files/DLLs required.
7. Script can be run on local user account only, no Administrator rights required.
Script should run on PC with:
1. Windows 10 20H2 and later version (Windows 11 is optional) installed.
2. Office 365 32-bit version installed installed.
It is allowable to download and install Microsoft Jet or Microsoft ACE database drivers should script requires it. 3rd party MS Access drivers (not from Microsoft) is not allowed.
Expectation:
The script can be executed from Windows command prompt or as a scheduled task. The purpose of the script is to have it running every hour unattended via Scheduled Task, and can be run manually when needed. The output .CSV file is "TAB delimited" text file.
The data needed from the database are just as follows:
1. Time of ID tap
2. Internal user ID
3. Device ID (this is the door access controller ID)
4. Employee ID
5. ID serial number
Data are arranged as table with first row as column header name.
Based on the "option" set during runtime, the script will open the database (specified file location) and filter the output based on the date/time range specified. As an example, script is run as below:
cscript.exe scriptname.vbs c:\database\database.mdb 10 20 30
where:
c:\database\database.mdb = name of the database to open
10 = number of days to fetch
20 = number of hours to fetch
30 = number of minutes to fetch
The output text file should contain the past 10 days and 20 hours and 30 mins of data fetched from the database. Suppose the script ran on October 20, 2021 @ 23:00hrs, the output file should contain data from October 10, 2021, with start of data from 02:30hrs, up to the time the script is ran.
Reach out directly to me if need more info.
What I require:
1. Script needs to be vbscript (text-based, executed by Windows cscript.exe).
2. Script should have option to fetch data based on specified date/hours/minutes at runtime.
3. Script should have option to specify the location of the database at runtime.
4. Script output is text-based (.csv).
5. Script is NOT obfuscated for checking and validation by IT Security group.
6. Script does NOT require custom app/3rd part apps to run. Should be running on built-in Windows 10 with NO helper files/DLLs required.
7. Script can be run on local user account only, no Administrator rights required.
Script should run on PC with:
1. Windows 10 20H2 and later version (Windows 11 is optional) installed.
2. Office 365 32-bit version installed installed.
It is allowable to download and install Microsoft Jet or Microsoft ACE database drivers should script requires it. 3rd party MS Access drivers (not from Microsoft) is not allowed.
Expectation:
The script can be executed from Windows command prompt or as a scheduled task. The purpose of the script is to have it running every hour unattended via Scheduled Task, and can be run manually when needed. The output .CSV file is "TAB delimited" text file.
The data needed from the database are just as follows:
1. Time of ID tap
2. Internal user ID
3. Device ID (this is the door access controller ID)
4. Employee ID
5. ID serial number
Data are arranged as table with first row as column header name.
Based on the "option" set during runtime, the script will open the database (specified file location) and filter the output based on the date/time range specified. As an example, script is run as below:
cscript.exe scriptname.vbs c:\database\database.mdb 10 20 30
where:
c:\database\database.mdb = name of the database to open
10 = number of days to fetch
20 = number of hours to fetch
30 = number of minutes to fetch
The output text file should contain the past 10 days and 20 hours and 30 mins of data fetched from the database. Suppose the script ran on October 20, 2021 @ 23:00hrs, the output file should contain data from October 10, 2021, with start of data from 02:30hrs, up to the time the script is ran.
Reach out directly to me if need more info.