Thanks,

I worked before with ADO through VB6.0.
Just wanted to be sure, VBA will support the
commands, and excel won't crash etc., since
I won't get more than an hour to work on the
project, in a day

Will start working now :)

Sharad

"keepITcool" wrote in message
ft.com...
YES.

Start to experiment with QueryTables to see if they support
what you want to achieve.

Then do research on ADO, to give you full control.

Probably easiest is to setup some well defined parameterized queries
in the MDB. then query those from excel.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Sharad Naik wrote :

Have a more than different dozen templates, with code.
Presently using Template Wizard for generating and maintaining data
bases in to a single excel file from all the templates.

Now we have to move to Access data base, i.e. the all
generated data will be stored in an access data base file.

Before I go on working on this, I just want to know, does VBA
supports necessary commands, to put data from various cells, in to an
access database (mdb file)? , like
opening the database file providing password, reading the available
fields, finding a string in one of the fields, then inserting
strings, integers, float, dates, boolean etc. ?

I just want to know from expert(s), who know or already worked with
simillar situation, does vba support the necessary database commands,
and does excel - access database comibination work flawlessly.

Thanks in advance
Sharad