Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and Access
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and Access
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel and Access
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
Access data -work in Excel- save in Access | Excel Programming | |||
Getting Access Error Messages when running Access through Excel | Excel Programming |