TheBG Posted June 26, 2013 Posted June 26, 2013 To all, I'm probably a mid-level Autoit user. Currently I have a script that I tun against pc's in the company. I collect various data and reg entries, and write all the data to a text file (csv). I then have an excel file that imports the text file as a data source, and the data is viewed by several co-workers. the data is growing faster than expected, and I need to start storing the data into a Access DB (office 2007). Then I can run various reports from Access. Note: I would start pushing it to SQL, but I'm uncertain of the requirements of the target pc's that are writing the data. please correct me if im wrong. So, I have looked around the forum, and have seen a access UDF and a couple of SQL type UDF's. What would be the recommendation of the path to follow? the only thing I need, if for the target pc's to write data to the DB, and that's it. I just want to re-write my code so it's writes to a DB instead of a text file.
Moderators JLogan3o13 Posted June 26, 2013 Moderators Posted June 26, 2013 It really depends upon your needs. How big do you now expect the data to get? Will all the machines that write to the db have Access installed? What is your comfort level with Access? Have you looked into the _SQLite functions in the help file, which will output to a file and do not need Access to read from/write to? All of these questions need to be answered before you can really make a determination which solution is best. "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum!
spudw2k Posted June 26, 2013 Posted June 26, 2013 You an also use ADODB to work with an AccessDB as it is essentially a JET database. There is an example in my signature. I'm not sure how the performance compares to SQLIte though. Spoiler Things I've Made: Always On Top Tool ◊ AU History ◊ Deck of Cards ◊ HideIt ◊ ICU ◊ Icon Freezer ◊ Ipod Ejector ◊ Junos Configuration Explorer ◊ Link Downloader ◊ MD5 Folder Enumerator ◊ PassGen ◊ Ping Tool ◊ Quick NIC ◊ Read OCR ◊ RemoteIT ◊ SchTasksGui ◊ SpyCam ◊ System Scan Report Tool ◊ System UpTime ◊ Transparency Machine ◊ VMWare ESX Builder Misc Code Snippets: ADODB Example ◊ CheckHover ◊ Detect SafeMode ◊ DynEnumArray ◊ GetNetStatData ◊ HashArray ◊ IsBetweenDates ◊ Local Admins ◊ Make Choice ◊ Recursive File List ◊ Remove Sizebox Style ◊ Retrieve PNPDeviceID ◊ Retrieve SysListView32 Contents ◊ Set IE Homepage ◊ Tickle Expired Password ◊ Transpose Array Projects: Drive Space Usage GUI ◊ LEDkIT ◊ Plasma_kIt ◊ Scan Engine Builder ◊ SpeeDBurner ◊ SubnetCalc Cool Stuff: AutoItObject UDF ◊ Extract Icon From Proc ◊ GuiCtrlFontRotate ◊ Hex Edit Funcs ◊ Run binary ◊ Service_UDF
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now