Sign in to follow this  
Followers 0
Arrrghmatey

send SQL to Access database?

3 posts in this topic

I have an access database, and I want to send some SQL statements to it and get back the results. Is there a way to do this with autoit? I know that with Java, for instance, there is a 'bridge class' (or something) but for Autoit, I don't know where to start...

Share this post


Link to post
Share on other sites



I have an access database, and I want to send some SQL statements to it and get back the results. Is there a way to do this with autoit? I know that with Java, for instance, there is a 'bridge class' (or something) but for Autoit, I don't know where to start...

<{POST_SNAPBACK}>

Search Scripts and Scraps, you'll need beta version of AutoIt.

SciTE for AutoItDirections for Submitting Standard UDFs

 

Don't argue with an idiot; people watching may not be able to tell the difference.

 

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

This is not a universal solution, but you may find it useful ..

If you setup some macros in the Access MDB file to execute your queries, I believe you can run them by launching the MDB from au3. Either with commandline parameters to Access (which I've heard about but never used myself) .. or by running them implicitly from an AutoStart macro in the MDB.

Hope this helps

:whistle:

edit = spelling and elucidation

Edited by trids

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0