Closed

Automatic Database Imports and Fuctions (Microsoft Access ONLY)

This project received 21 bids from talented freelancers with an average bid price of $ USD.

Get free quotes for a project like this
Employer working
Project Budget
$100 - $200 USD
Total Bids
21
Project Description

I need a dynamic Database that will Fetch/Import data DAILY and Automatically from a folder.

The playout software, generates each day a log file:

Example:

playout\_2012\[url removed, login to view]
playout\_2012\[url removed, login to view]
playout\_2012\[url removed, login to view]
playout\_2012\[url removed, login to view]


Inside each file it contains (4) rows of data:
**Row 1:** [dd:mm:yyyy hh:ss:mm:000]
**Row 2:** E:/PLAYOUT/folder/subfolder/[url removed, login to view]
**Row 3:** hh:mm:ss
**Row 4:** []=TAG

I need the Microsoft Access to this (5) functions:
1. Fetch/Import each file from folder _AUTOMATICALLY_ on daily basis (Every 24 hours)
2. On **Row 1**, separate the Date (dd:mm:yyyy) and Time (hh:ss:mm:000) to an individual row.
3. Change the Date format to **mm/dd/yy** (from dd:mm:yyyy)
4. Remove the string: "**E:/****Playout**"
5. Remove the string: "**[]=**"

The final rows must look like this, 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/[url removed, login to view]
**Row 4** (Duration)**:** hh:mm:ss
**Row 5** (Type)**:** []=TAG


**IMPORTANT NOTE: **FOR THIS TO WORK FINE, THE DATABASE MUST ONLY FETCH THE DATA FROM THE PREVIOUS DAY, SINCE THE SOFTWARE GENERATES THE LOG ON THE FLY AND IF MS-ACCESS 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)

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online