Storing an Excel template in Access

[Montez659]

Is there any way to store an excel template inside of Access?

I am planning on creating in code a function that will create a new excel file and populate that file based on an Access query for future data collection, but the spreadsheet has a fe images attached to it, and I thought it better to be able to copy a template and create a new file and populate it instead of having to recreate it programatically each time.

If I can't store it, then I was thinking that I would split the db and maintain the file I need in the same folder as the back end, but I am really not wanting to split the file and I am afraid that it would get moved/deleted/changed.

 

[boblarson]

It is much easier to use it if you store it in a file folder than trying to store it in Access. It is next to impossible to use it when stored in Access and you'll find it takes a lot more work even than just recreating it via code. So I would say store the template and maybe include _DoNotMoveThisFile_ as part of the file name.

 

[Montez659]

Bob, thanks for the input. I will stay away from storing it in Access!