<div>
in your distribution package, how about putting the Excel template in the same directory as the database, or a known folder below. &nbsp;Then have a button to create an Excel file to fill and make it using the template. 
 
There is no way, that I know of, to include an Excel Template IN the Access file unless it was an object -- at that point it may as well be external as there would be gymnastics to use it as a template. &nbsp;You could, however, embed all the code it takes to make it. Again, the file to fill would have to be created using Access.
</div>

<div>
Crystal, 
 
I have an idea. I have a table called 'tblSettings'. This table holds one record and is unrelated to any other records. Bascially one record to hold the various user display settings. I created an attachment field in that tblSettings records called DownloadTemplate. i uploaded the Excel Template as an attachment to that record field and it works great. Now here is where I am stuck. 
I want to place that attachment field on the frmClass form so users can simply double click on he attachment and download he Excel file. The problem I am having is that tblSettings does not relate to any records on the form (bound to tblClass) so I can't seem to drop the field onto the form. I tried a dlookup function on the attachment control hoping to grab the value from the tblSettings.DownloadTemplate field but it's not working (no file shows up). 
 
Here is my Dlookup on the attachment control: =DLookUp(&quot;[tblSettings]&quot;,&quot;[DownloadTemplate]&quot;) 
 
Thoughts? 
 
Mike
</div>

<div>
use a subform and bind it to the table (or a query that just gets one record) and has the attachment control -- however you may wish to use an OLE field since an attachment can have multiple values -- not sure as I wouldn't do it this way so I have never tried. &nbsp;DLookup can't return an object.
</div>

Example.accdb

<div>
Gustav, 
 
This is great! Works like a charm! Actually I modified your code to grab the user's path to the desktop and just save there for now: 

<pre><code class="code-10 nolinks" id="code-20-41826252-1"> 
 
 Dim dbs As DAO.Database
 Dim rst As DAO.Recordset2
 Dim rsA As DAO.Recordset2
 Dim fld As DAO.Field2
 Dim strPath As String
 Dim strUserName As String
 
 'Get the database, recordset, and attachment field
 Set dbs = CurrentDb
 Set rst = dbs.OpenRecordset(&quot;tblSettings&quot;)
 Set fld = rst(&quot;DownloadTemplate&quot;)
 
 strUserName = Environ(&quot;UserName&quot;)

 strPath = &quot;C:\documents and settings\&quot; &amp; strUserName &amp; &quot;\Desktop&quot;
 
 
 'Navigate through the table
 Do While Not rst.EOF
 
 'Get the recordset for the Attachments field
 Set rsA = fld.Value
 
 'Save all attachments in the field
 Do While Not rsA.EOF
 strPath = strPath &amp; &quot;\&quot; &amp; rsA(&quot;FileName&quot;)
 
 'Make sure the file does not exist and save
 If Dir(strPath) = &quot;&quot; Then
 rsA(&quot;FileData&quot;).SaveToFile strPath
 End If
 
 'Next attachment
 rsA.MoveNext
 Loop
 rsA.Close
 
 'Next record
 rst.MoveNext
 Loop
 
 rst.Close
 dbs.Close
 
 Set fld = Nothing
 Set rsA = Nothing
 Set rst = Nothing
 Set dbs = Nothing
 
 
</code></pre>
</div>

<div>
You are welcome! 
 
/gustav
</div>

<div>
<div class="content wysiwyg-content">
Dear Experts, 
My Access for has an import button to import records from Excel spreadsheet. The process works fine but what I need to do is to make an Excel file template available for users to 'download' and use to fill in there records into the template and 'use' that template to import the records. Is there a way to 'embed' the spreadsheet file so when I commercialize the application any user can 'download' the template from the application without having to 'include' the template excel file with the Access Database file. Somewhere down the line the excel file might get lost if I simply 'link' to the file. I'd like to embed if possible. 
If not, I suppose the only thing I could do is to create a little help form that provides the user information on 'how to setup' up their excel file for import.
</div>
</div>

Dear Experts,
My Access for has an import button to import records from Excel spreadsheet. The process works fine but what I need to do is to make an Excel file template available for users to 'download' and use to fill in there records into the template and 'use' that template to import the records. Is there a way to 'embed' the spreadsheet file so when I commercialize the application any user can 'download' the template from the application without having to 'include' the template excel file with the Access Database file. Somewhere down the line the excel file might get lost if I simply 'link' to the file. I'd like to embed if possible. 
If not, I suppose the only thing I could do is to create a little help form that provides the user information on 'how to setup' up their excel file for import.

MS Access embed an Excel downloaded template file  on form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.