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 |
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 |