Database Capabilities (Read/Write/Delete/Update)

[MGuyM]

I've been toying with an idea and I've got some questions about whether it's possible to do it using MS or not.

I have a process that I'd like to run every day. It would read data from a Database (or INI File or some sort of a Database), it would do a process and then it would record the date/time that the process was performed. When the process runs the next day, it would have to read the data/time of the last time it was processed and if it's less then 24 hours, it would have to wait or skip the line of data that it's processing. However, I would want the process to go back to that line of data after 24 hours have successfully passed.

I'm sure that If the data was in a SQL Database, that it could be read in a sorted order to make sure that the records are processing in the same sequence each day based on when the last record was processed from the data/time that get's recorded.

My Question is, can MS Read/Write this type of Data to a Database format and if so, Could someone help me with some examples of how to do it? I've read plenty on how to interact with a Database to retrieve data, but I haven't found anything on updating or modifying the data in the Database.

I'm thinking I might have to use Access/VBA in order to accomplish what I want, but I would much rather get a solution with MS since MS will provide me with a method in which I could compile my Script as an EXE and make it available to others who might benefit from it.

As Always, Thank You for the Speedy replies and I look forward to a response.

[Marcus Tettmar]

Yes, you can do this. Use DBExec to modify/insert data in a SQL database. See: http://www.mjtnet.com/blog/2008/04/15/u ... functions/