Access to SQL Import Utility

We posted this a while back however we have had to modify it a little so feel free to re-bid. We need an application that will run on a Windows 2000 Server as a service that will read an Access 2000 database and port the values every (Selectable from 10 sec, 30 sec, 1 min , 5 min, 10 min intervals) to a SQL 2000 Server database. ## Deliverables The Access database is continuously adding values and will purge itself every couple days in a maintenance cycle so this application must be continuously checking for new data (records) The application that the Access database was developed for runs on a maintenance schedule to purge the Access Database. When the maintenance cycle begins it creates a file called "[login to view URL]" in the application's local directory, and upon maintenance completion, it replaces that file with a "[login to view URL]" file. So basically, it requires any third-party applications to check for the presence of the "mOK" file before opening the access database. The Access database does have a unique ID for each record that increases for each record so you can keep track of what data has been added that was not already imported to the SQL server. We would like some kind of error notification in case the application stopped working or encountered a problem or error this would include if a record was not added in (Selectable 3 hours, 6 hours, 12 hours, 1 day, 3 days etc...) Error checking is very important to us since each record is very important we must be told what the error was, when it happens, if the record was successfully imported etc... (Also emailed if it encountered a problem AND logged in a Text file for further diagnosis of the problem.) We see the notification as simply as sending an email out to one or more addresses. Some notable points to keep in mind 1. The Access database is readable only although we could make it writable such as a field saying Imported? (Yes/No) we would prefer not to edit or disturb this programs functionality. 2. The SQL must have the data as quickly as possible from the Access Database 3. It must conserve resources no matter how it moves the data 4. It must NOT import duplicate data 5. It must be reliable and fully automatic & Manual (if needed) 6. It can not interfere with the data that is being written in real time (meaning you can not lock the database while you do the export/import) 7. We would like the GUI utility to have a nice easy to use Interface. Some kind of status screen that we can see the current operating status (Currently importing XXX record etc...) 8. There is only ONE table in the database with 9 field of data that will be exported. Part 2: We want this application to do everything as formentioned above however the software provider is configuring a beta utility that will Export new records every minute to text files (CVS and HTML) to a folder. We want this application to ALSO be able to as a SETTINGS Option to either be able to pull data from the database AND OR to purge the Text file and then Delete the file when it is done. So basically it would look in a folder for a text file every (Selectable from 10 sec, 30 sec, 1 min , 5 min, 10 min intervals) read the files and import them as records into the SQL database and once it is done it would DELETE the file. Since The Utility that will be installed will create a NEW file every minute so the application must delete it so that there is not 1000's of exported text data. We also want a good audit trail and error reporting so we know what was last imported and what error happened etc... And additionally there is one HTML document that contains a daily report summary from the parent program. We need to have this application parse this document once a day and enter it into the SQL server (data only) This must happen regardless of the Access or CSV method of data importing and be configurable (on, off, how often, etc..) We want this application to be selectable to use either method of data extraction. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased ## Platform To further clarify this utility it must be able to pull data from either Access or CVS files. Meaning if we wanted it to do BOTH we could select a seperate database table in SQL for one and another one for the other or we could simply do one. It must have an easy selectable way of doing this. However it should not be able to use both methods while using the same SQL table (Double records) It also needs to have a Data lookup table on the SQL server that will look up the Sensor ID and place it in the correct table. This table could be the one to store the final table location in SQL. The a defualt table for values not found in the lookup table. We would also like it to be done in either Visual Basic and/or VB.NET. We want a simple installation procedure with a good friendly user interface for running and installing/configuring.