Automatic Database Imports and Fuctions (Microsoft Access ONLY)
$100-200 USD
货到付款
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)
项目ID: #2675760