Automatic Database Imports and Fuctions (Microsoft Access ONLY)

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\[login to view URL] playout\_2012\[login to view URL] playout\_2012\[login to view URL] playout\_2012\[login to view URL] Inside each file 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 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/[login to view URL] **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)