Excel and Access

[Sharad Naik]

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

 

[keepITcool]

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 :

 

[Sharad Naik]

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