Automatic Database Imports and Fuctions (Microsoft Access ONLY)

已完成 已发布的 Nov 20, 2012 货到付款
已完成 货到付款

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# 编程 微软Access 软件构架 Visual Basic的应用程式

项目ID: #2693022

关于项目

13个方案 远程项目 活跃的Nov 20, 2012

授予:

nlukovic

I can do this for you. Thanks, Nebojsa

$30 USD 在2天内
(17条评论)
5.1

有13名威客正在参与此工作的竞标,均价$99/小时

Rahul2012

Please check your PM.

$98USD 在1天里
(29条评论)
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 在2天内
(36条评论)
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 在5天内
(17条评论)
5.1
dzelo

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

$200 USD 在2天内
(12条评论)
5.1
pkcyber

See your PMB.

$65 USD 在2天内
(12条评论)
4.8
aegansys

C/C++/C# DEVELOPER

$30USD 在1天里
(9条评论)
3.7
neuminds

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

$150USD 在1天里
(2条评论)
2.6
benefitworks

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

$30USD 在1天里
(2条评论)
2.2
ngocthanhtnt

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

$50 USD 在5天内
(0条评论)
0.0