MS Access - Archive Tables then Import new Tables via VBScript if possible
Posted on 2009-02-16
I have a very large question that I was wondering if anybody here could help.
We use "Retina" as our network security scanner at work. It's a fairly decent program that audits any and all vulnerabilities on workstations accross the whole enterprise. When you run a scan using Retina, it saves the information as a file with an "rtb" extension that can be opened in MS Access to view all the tables, etc.
My question is then, I have an MS Access database that's tracking the mitigation of all the vulnerabilites in our network, up to the point of resolve. There's a TON of cutting/pasting involved, but what I'd like to do - is create a button on a form, or use a function in access - that does alot of that work for me.
I'd like to have a button that I push that asks where the Retina filename is stored. It would then backup all the previous data into an archive of sorts, then purge the tables of anything - and then import the new data from the RTB file into the required tables.
The RTB file structure is always the same as far as the tables, etc. are concerned - the only difference between scans is the filename of whatever we give it for that particular day.
Any information you guys can provide would be greatly appreciated on this topic. Thanks in advance.