Jump to content

send SQL to Access database?


Recommended Posts

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...

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.

 

Link to post
Share on other sites

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
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
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...