Excel Template Population Issue from Access (Specific Setup) *Office 2013*

[wingzero]

Hello I was seeing if anyone could help me out on a very specific Excel Template population question. I am having an issue just trying to get started and don’t really know where to begin. I have some basic knowledge of using macros in excel but I don’t really think that could apply here very easily as I have 164 templates to populate as quickly and efficiently as possible for the situation.



I have added a pdf that I made trying tolayout the situation and how things are connected. Basically each Excel Template is named after a CONFIG_ID. I am just wanting to populate the worksheet tabs (20 of them which are “OPTION_ID types”) with the options thatare in the database tables for the specific options (Shown and explained better in the image).

If you have any other questions on the scenario feel free to ask and I will clarify the best I can. If you have any ideas about how I may be able to do this or where I can begin looking for similar scenarios I would appreciate it. Also any ideas that you have try to describe them in the simplest terms possible as I am not program savvy at all and I am new to this type of situation.

Thanks for all of the help.

[ssanfu]

Totally confused

Each Option_ID has many PIDs and each PID has 1 or more Parameter_Values?
Do you have a query that has all of the data?

Using VBA automation, you can open an Excel spreadsheet, select (or create) a tab, put the data in the appropriate cell and close/save the worksheet.

There is a lot of info that should help at Ken Snell's site at:
Data Imports and Exports with EXCEL Files
http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm

[June7]

Did you consider link from Excel to Access?

VBA behind Excel can open connection to Access and pull data from Access and set values of cells.

VBA behind Access can open Excel object and set values of cells.

Code is not simple but is a common topic. Bing: access vba excel template

http://social.msdn.microsoft.com/For...e?forum=isvvba

[wingzero]

Thank you guys for your suggestions. I will look into those areas and reply with other questions as they arise. Sorry about not making everything a little clearer. (Kind of confusing when there are 3 tables in Access with data having to come from all of them to get the information to put into the cells.)