Export from Access to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I export data every week from Access 2000 to Excel. The data is a query
listing about 100 service calls showing downtime. I then total the downtime,
insert another worksheet in the workbook and do various calculations down one
column with the answers in the next column to to give me a summary sheet and
a detail sheet (the original data). I can do the calculations on form in
Access 2000 but if I export the form the filed names go across the top of
the sheet with the results below, not down one column. Can I export data to a
template and pick the cells the data gets inserted in or is there a better way
 
Thank you for your help I think I can do it now but I'll leave this open (I'm
not very good at code yet but I'm determined
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating an Excel table from Access 1
Link Access to Excel export back to excel 3
Rounding difference in Access 2003 text exports 2
export to exce spread sheet 1
Exporting Query from Access 2007 to Excel 2007 4
Exporting Data from access and appending to an existing excel sprd 3
Remove borders when ms access 2007 performs an export to excel? 4
export to excel and save 4

Back
Top