Automatic Database Imports and Fuctions (Microsoft Access ONLY)

Closed

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)

Skills: Script Install, Shell Script, Windows Desktop

See more: daily access, 4 tries, yy, windows automatic, hh, fly to ms, fly for ms, windows log script, create access database reports, hours access database, dynamic database, access functions, access database work hours, work hours database access, import data database database, daily log access, import data access, import function access, automatic file, access daily, create folder access, access rows, will automatic, windows date change software, file access time windows

Project ID: #2675760