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: 68
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,169
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


Hi
What are you exporting from..???
thumbup.gif

--------------------
"Time...We have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresa, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein"
H. Jackson Brown
Go to the top of the page
 
Quinto1
post Apr 11 2018, 08:33 AM
Post#3



Posts: 68
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,169
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

--------------------
"Time...We have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresa, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein"
H. Jackson Brown
Go to the top of the page
 
Quinto1
post Apr 11 2018, 09:00 AM
Post#5



Posts: 68
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    20th August 2018 - 08:52 PM