Import text file in database from running code in different ms access file

[MUKESHY12390]

Hi All,

How can I shuffle between two MS Access Database via VBA. Here is the task I would like to perform

I have three Access files 1) template (basically this would have all code) 2) Database ONE 3) Database TWO.

through "Template" I will open database ONE ...run query and import One text file into table which already exits. Same goes with second database as well.

Thanks

any help would be appreciate

 

[MUKESHY12390]

**** i'm so dump...it was so easy

just ..set oAccess = new Access.application