Novice
Windows 7 64bit 
Access 2010 64bit
i have a query in a database which basically outputs and shows the person there jobs for that day. At the moment we are having to print it on preprinted paper but what i want to do is output it into excel where we have a template for this.
I.E so there persons name goes into the name cell and the jobs and times go in the correct boxes as well.
i have found some stuff on the web which i can get it to output to excel but not formatted how i want.
can anyone help
VIP
Windows XP Access 2010 32bit
What's wrong with the formatting? Code can be used to set format of cells.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Expert
Windows XP Access 2010 64bit
Here are a couple of threads from this forum that may help:
https://www.accessforums.net/showthr...ted-Excel-Data
https://www.accessforums.net/showthr...ccess-to-Excel
Novice
Windows 7 64bit Access 2010 64bit
thank you for the replies, it wasn't so much the formatting of the cells i just wanted particular info to go into particular cells.
VIP
Windows XP Access 2010 32bit
And another thread http://forums.aspfree.com/microsoft-...el-413629.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Exporting to formatted Excel file
Posting Permissions
Reply With Quote