Hi all, I have the following problem that i need to solve, but probably cant see the wood for the tree's. I have a Data Capture System that puts data into an mdb file, a new file is created daily with the filename structure YYYYMMDD.mdb The structure of the data never changes just the filename I also have a MS SQL database Setup and used http://www.digitalvolcano.co.uk/mdbmerge.html to merge the existing Mdb files into one and imported all the existing data, i can also manualy run a DTS package every day to import the new file, BUT what happens when i go away on holiday, if no one knows how to do this, the reports i am writing will be useless until i come back. So what i require help with is: How do i actually get the DTS Package to look for Today's Date and decide that it needs the filename to be yesterdays date. For Instance Today = "20070830" Filename will Be = "20070829.mdb" if this is possible please let me know Steve
Hello, You can look at http://dbconvert.com/convert-access-to-mssql-sync.php May be it might be possible to play your scenario using Access2MSSQL Sync + DC Scheduler, which automates tasks.