Sign in to follow this  
Followers 0
Andre Celie

Using Autoit to access a msaccess database

3 posts in this topic

I am looking for some code on how to access a Ms Access database.

I want to query a table and then make a selection, and then make a configuration file.

Is this possible

I just need a small example, with 1 or more queries.

Thanx

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

I am looking for some code on how to access a Ms Access database.

I want to query a table and then make a selection, and then make a configuration file.

Is this possible

I just need a small example, with 1 or more queries.

Thanx

you can use my dbase handling script for autoit first export access data

func to handle database into autoit

FIRST YOU SHOULD MAKE A SMALL SCRIPT TO EXPORT your acces sql into dbf

=================

FIRST: export desired access query into yourtable.dbf

==================

SECOND STEP: -----------

$alldataishere=DBASE ("USE YOURtableÇset alter onÇLIST OFF NAME,AGE Çset alter off", "tmpasciifile")

-----YOU GET THE WHOLE TABLE INTO ASCII:(it produces an ascii file with all data in the yourtable.dbf)

=================================

you show this info and select with autoit front end

=========================

THIRD STEP:

$Wautoitselectvariable =" AGE=5 "

$allSelecteddataishere=DBASE ("USE yourtableÇset alter onÇLIST OFF NAME,AGE FOR " & $Wautoitselectvariable & "Çset alter off", "tmpasciifile")

----------- you get your selected value got from autoit front end into the dbase query

-------------(it produces an ascii file with THE SELECTed data in the yourtable.dbf translated into ascii or var)

(instead of ascii file you can get data directly in a variable)

$SelectedPeople =

Edited by BasicOs

Autoit.es - Foro Autoit en Español Word visitors Image Clustrmap image: - Football Spanish team - Spanish team: Casillas, Iniesta, Villa, Xavi, Puyol, Campdevilla, etc..Programando en Autoit+Html - Coding Autoit-Html - Arranca programas desde Internet - Preprocesador de Autoit a http

Share this post


Link to post
Share on other sites

“Give a man a script; you have helped him for today. Teach a man to script; and you will not have to hear him whine for help.”AutoIt4UE - Custom AutoIt toolbar and wordfile for UltraEdit/UEStudio users.AutoIt Graphical Debugger - A graphical debugger for AutoIt.SimMetrics COM Wrapper - Calculate string similarity.

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