Guest dorian Posted June 8, 2004 Hi there. I'm a newbie so please forgive me if this has been answered somewhere. I've searched the forum and help and haven't come across this topic. Is there anyway to attach to a database and read from the tables? Is that something that AutoIt is capable of? (I'm trying to avoid using csv files.) If the answer is yes, can you please direct me to where I may find examples of the correct syntax for the connection string? Thanks D Share this post Link to post Share on other sites
Nutster 3 Posted June 8, 2004 AutoIt is not designed to interface with databases. AutoIt can read and write text files, but not binary files or ODBC connections. This is outside of the scope of AutoIt. David NuttallNuttall Computer ConsultingAn Aquarius born during the Age of AquariusAutoIt allows me to re-invent the wheel so much faster.I'm off to write a wizard, a wonderful wizard of odd... Share this post Link to post Share on other sites
trids 2 Posted June 9, 2004 Ummm .. this may not be exactly what you're after, but keep an eye on the Scripts and Scraps forum: I'll be posting a note on how to use AU3 to wrap a SYBASE / SQL-Server commandline utility (called isql.exe) so that you can execute SQL queries from a text-editor like Textpad.You might be able to hack it around for your purposes Share this post Link to post Share on other sites
Guest dorian Posted June 9, 2004 (edited) Great! Anything that will help me avoid returning to the cumbersome task of extracting data from a csv will be totally appreciated. Thank you. Edited June 9, 2004 by dorian Share this post Link to post Share on other sites
Nutster 3 Posted June 9, 2004 (edited) There are several freeware/open source databases available. Take a look on Source Forge for some examples. Look for Database Client and ODBC Client.Edit: fixed link. Edited June 9, 2004 by Nutster David NuttallNuttall Computer ConsultingAn Aquarius born during the Age of AquariusAutoIt allows me to re-invent the wheel so much faster.I'm off to write a wizard, a wonderful wizard of odd... Share this post Link to post Share on other sites