<div>
instead of using transferspreadsheet, I would recommend using Excel Automation, which would allow you to use the copyFromRecordset method to push data from Access into a specific cell in range in Excel. 
 
On my way out of the office for a meeting, but do a search on &quot;CopyFromRecordset&quot; here in EE and you should find some code for that. 
 
Dale
</div>

instead of using transferspreadsheet, I would recommend using Excel Automation, which would allow you to use the copyFromRecordset method to push data from Access into a specific cell in range in Excel.

On my way out of the office for a meeting, but do a search on "CopyFromRecordset" here in EE and you should find some code for that.

Dale

Data Engineer

Fordraiders

<div>
<div class="content wysiwyg-content">
Access 2010 
Excel 2010 
 
vba routine to export chnage to specific columns on a excel workbook template. 
 
I have a query setup to export. 
Set NewQuery = CurrentDb.CreateQueryDef(&quot;Export_Temp_Subform_Query&quot;, sql) 
 
 
strUserName = Environ(&quot;username&quot;) 
strPath = &quot;C:\Users\&quot; &amp;&nbsp;strUserName &amp;&nbsp;&quot;\desktop\Export_Temp_Subform_Query.xls&quot; 
 
&nbsp; &nbsp; DoCmd.OutputTo acOutputQuery, &quot;Export_Temp_Subform_Query&quot;, acFormatXLS, strPath, True 
 
 
What I need: 
To Specifically export to a Excel workbook.. called &nbsp;&quot;Export_InPut_Data.xlslx&quot; 
 
I need Field(0) in the recordset to go to ColumnA in the workbook. 
I need Field(1) in the recordset to go to ColumnB &nbsp;etc.... 
 
The cells on this workbook are FORMATTED &nbsp;exactly as i need them. 
I'm hoping when the export is completed the formatting stays in place in the EXCEL workbook ? 
 
 
Thanks 
Fordraiders
</div>
</div>

Access 2010
Excel 2010

vba routine to export chnage to specific columns on a excel workbook template.

I have a query setup to export.
Set NewQuery = CurrentDb.CreateQueryDef("Export_Temp_Subform_Query", sql)


strUserName = Environ("username")
strPath = "C:\Users\" & strUserName & "\desktop\Export_Temp_Subform_Query.xls"

    DoCmd.OutputTo acOutputQuery, "Export_Temp_Subform_Query", acFormatXLS, strPath, True


What I need:
To Specifically export to a Excel workbook.. called  "Export_InPut_Data.xlslx"

I need Field(0) in the recordset to go to ColumnA in the workbook.
I need Field(1) in the recordset to go to ColumnB  etc....

The cells on this workbook are FORMATTED  exactly as i need them.
I'm hoping when the export is completed the formatting stays in place in the EXCEL workbook ?


Thanks
Fordraiders

To Specifically export a sql query to a Excel workbook

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

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.