Using Autoit to access a msaccess database

[Andre Celie]

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

[BasicOs]

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 January 29, 2006 by BasicOs

[Stumpii]

You can try this:

http://www.autoitscript.com/forum/index.ph...topic=20736&hl=