UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Export To Temp Plate, Any Versions    
 
   
Quinto1
post Apr 11 2018, 08:26 AM
Post#1



Posts: 90
Joined: 23-April 16



Can I export to an excel template that has heading in the first 2 rows>
See attached, what do I need to change to make it work?
Thank you

Go to the top of the page
 
Larry Larsen
post Apr 11 2018, 08:29 AM
Post#2


UA Editor + Utterly Certified
Posts: 24,383
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


Hi
What are you exporting from..???
thumbup.gif
Go to the top of the page
 
Quinto1
post Apr 11 2018, 08:33 AM
Post#3



Posts: 90
Joined: 23-April 16



Hi,
I export from an MS Access Query
Go to the top of the page
 
Larry Larsen
post Apr 11 2018, 08:52 AM
Post#4


UA Editor + Utterly Certified
Posts: 24,383
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


Hi
Couple of options that you could use.. (there are many... actually)
Access VBA DoCmd.TransferSpreadSheet Method
or
Access VBA DoCmd.OutputTo Method

These were just a couple of quick searches, using Export To Excel from Access..
HTH's
thumbup.gif
Go to the top of the page
 
Quinto1
post Apr 11 2018, 09:00 AM
Post#5



Posts: 90
Joined: 23-April 16



Since I really don't know VBA I will stick with the Export command and just export to excel.

Thank you

Quinto
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    21st November 2019 - 09:04 AM