Closed

Data Extraction from MS Access database on Windows 10 20H2 via script

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 [login to view URL]).

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:

[login to view URL] [login to view URL] c:\database\[login to view URL] 10 20 30

where:

c:\database\[login to view URL] = 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.

Skills: Microsoft Access, Visual Basic, VBScript

See more: vbnet access database windows mobile, create access database windows, read access database windows script host, access database windows mobile, access ms access database manually, attendance ms access database, backup restore ms access database vb net windows application, cheap ms access database design, code store text form vb project ms access database, coding save data vb ms access, data decrypted ms access database, extract images stored ms access database long binary data format, how to insert data into ms access database using javascript, how to insert data into ms access database using html, how to get data from ms access database in c#, how to connect ms access database in c# windows application, how to insert data into ms access database using php, how to retrieve data from ms access database in c#, how to create odbc connection for ms access in windows 10

About the Employer:
( 1 review ) Makati City, Philippines

Project ID: #31774495

10 freelancers are bidding on average $166 for this job

(64 Reviews)
6.4
(98 Reviews)
5.8
XeeChaun

hi. I have 8+ years of experience with ZKTeco access devices. I have done a number of similar projects. here are couple of my projects: ---( https://www.freelancer.com/projects/c-sharp-programming/ZKteco-download-recor More

$250 USD in 5 days
(15 Reviews)
5.4
gangabass

Thank you for the excellent project description! I can provide you a simple .vb script that will work exactly like you want: it will read selected mdb file, filter records and output into tab separated file. Roman

$200 USD in 2 days
(46 Reviews)
5.2
kingqueen369

Hi, Greetings! ✅checked your project details :Data Extraction from MS Access database on Windows 10 20H2 via script ✅Completed Time : 24 hours or your requirement deadline . I would like to work on your project and w More

$100 USD in 1 day
(43 Reviews)
5.1
crypthne

I'm an experience .NET developer, have been in this field for more than 5 years and working with many .NET related project (using C#/VB/ASP.NET with Angularjs). I also a MS Access and VBA developer, I've been in this f More

$100 USD in 7 days
(36 Reviews)
4.7
(4 Reviews)
4.6
abeseela

Good day! I can create you a data extraction tool using Visual Basic .NET which is very much similar to VBScript. The tool will require no 3rd party software / dependencies to run and it will run on any PC once, .NET More

$150 USD in 5 days
(4 Reviews)
3.0
karanugale

Hi, I am a professional software developer and I can help you with this. My previous developed software are still running on Microsoft Access Database and sometimes I need to fetch data from them so I have developed a More

$200 USD in 30 days
(0 Reviews)
0.0
Kiasemoto

Hi, Clear requirement, this should be doable using standard windows installation + ace drivers. Please contact me for further discussion Cheers.

$180 USD in 2 days
(0 Reviews)
0.0