Automatic Database Imports and Fuctions (Microsoft Access ONLY)

Completed Posted Nov 20, 2012 Paid on delivery
Completed Paid on delivery

I need a windows program or the same VBA that will fetch data from a folder (PlayoutLogs) DAILY and AUTOMATICALLY, then modify and store it to Microsoft Access Database.

(So that later anyone on the network can access this data and create special reports)

This folder comes from a playout software, that each day generates a log file:

Example:

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

Inside each Logs, it contains (4) rows of data:

Row 1: [dd:mm:yyyy hh:ss:mm:000]

Row 2: E:/PLAYOUT/folder/subfolder/[login to view URL]

Row 3: hh:mm:ss

Row 4: []=TAG

The automation must a preform these (5) functions always:

1. Fetch/Import each Log from folder AUTOMATICALLY (Once Every 24 hours) to Microsoft Access Database.

2. Split Rows 1, into to (2) separate Rows for Date (dd:mm:yyyy) and one for Time (hh:ss:mm:000).

3. Then, change the Date format from “dd:mm:yyyy” to mm/dd/yy

4. Remove this : “E:/Playout”

5. Remove this : “[]=”

The FINAL Rows must look like this in Microsoft Access, and I must then be able to create detailed reports for this data:

Row 1 (Date): mm/dd/yy

Row 2 (Time): hh:ss:mm:000

Row 3 (Source): /Folder/Subfolder/[login to view URL]

Row 4 (Duration): hh:mm:ss

Row 5 (Type): []=TAG

IMPORTANT NOTE: I THINK THE DATABASE MUST ONLY FETCH THE DATA FROM THE PREVIOUS DAY, SINCE THE PLAYOUT SOFTWARE GENERATES THIS LOG ON THE FLY AND IF MS-ACCESS/PROGRAM TRIES TO IMPORT A FILE FROM THE “SAME DATE”, IT WILL IMPORT AN 'UNCOMPLETED' LOG FOR THAT DAY.

(IF YOU HAVE A BETTER SYNTAX OR FUNCTION TO THIS, I AM OPEN TO DISCUSS)

PS. ATTACH IS THE SAMPLE FOLDER AND LOG FILES

.NET C# Programming Microsoft Access Software Architecture Visual Basic for Apps

Project ID: #2693022

About the project

13 proposals Remote project Active Nov 20, 2012

Awarded to:

nlukovic

I can do this for you. Thanks, Nebojsa

$30 USD in 2 days
(17 Reviews)
5.1

13 freelancers are bidding on average $99 for this job

Rahul2012

Please check your PM.

$98 USD in 1 day
(29 Reviews)
5.8
diegogarcia0531

Hi, I can do the job, MS Access, SQL, PL-SQL, VBA, VB6, VBNET, C#, Oracle, SQL Server, Firebird, MySQL expert

$100 USD in 2 days
(36 Reviews)
5.7
reechmeraj

Greetings!!! We are glad to bid on your project and would be more happy if get a chance to work on the same. Please see PMB for details

$100 USD in 5 days
(17 Reviews)
5.1
dzelo

This is my field of interest. Please check private message for more details.

$200 USD in 2 days
(12 Reviews)
5.1
pkcyber

See your PMB.

$65 USD in 2 days
(12 Reviews)
4.8
aegansys

C/C++/C# DEVELOPER

$30 USD in 1 day
(9 Reviews)
3.7
neuminds

I have a tool developed for data cleansing, data mapping from source to destination.

$150 USD in 1 day
(2 Reviews)
2.6
benefitworks

Greetings!!! I can do this. I am expert in vba. You can see my portfolio for more information. Regards, benefit works

$30 USD in 1 day
(2 Reviews)
2.2
ngocthanhtnt

Hello, I am up to the task, please send more information

$50 USD in 5 days
(0 Reviews)
0.0